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.
4 Replies
- 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!
Sbu_M1035 Let's say the numbers are in cells B2 to B10 and you want to sum them showing the result in B11. In B11 type =SUM(B2:B10) and press enter.
Many thanks for your kind response!
I tried your suggestion.....seems to work when numbers are uniform....if you have a mix of whole numbers and ones with decimal points, it does not seem to work.
Strangely, when I changed the decimal points for commas, bingo I could add/sum mixed whole numbers and those with commas....
could add
