Forum Discussion
Sbu_M1035
Sep 06, 2023Copper Contributor
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.
Brom_Nader
Sep 06, 2023Copper Contributor
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.
- Sbu_M1035Sep 06, 2023Copper Contributormany thanks, Brom. i just exchanged decimals for commas and it worked!