Forum Discussion
Solved
Adding decimal amounts together
I am trying to add a column of numbers together using Autosum, but it ignores any figures that includes a decimal point (i.e 10.25).
I have tried converting text to columns options and changing the format of cells to numbers, general and currency.
How can I fix this?
Lorraine,
maybe your system doesn't use the . (point) as the decimal separator but the , (comma).
3 Replies
Lorraine,
maybe your system doesn't use the . (point) as the decimal separator but the , (comma).
Thanks! That was exactly it! Dont suppose you know how I can change it so it recognises decimal instead of comma in the future?
As variant it could be
=SUMPRODUCT(VALUE(SUBSTITUTE(<your range>,".",",")))
instead of SUM. If that's the only you'd like to do with these numbers.
