Forum Discussion
Excel - adding numbers with decimal points
good day i am battling with the "sum" function - i am trying to add (sum) numbers with decimal points in a column.
The format of the sum does not have to be the same as the numbers in the column. Each cell's format is generally not dependent on the format of another cell. To fix this, click on a number in the column with the correct format. On the HOME tab, click on the paint brush at left. Then click on the cell containing the sum.
- many thanks, Brom. i just exchanged decimals for commas and it worked!
