Adding decimal amounts together

[Lorraine Calvey]

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?

[#2 · Accepted solution]

Lorraine,

maybe your system doesn't use the . (point) as the decimal separator but the , (comma).

[#3]

Thanks! That was exactly it! Dont suppose you know how I can change it so it recognises decimal instead of comma in the future?

[#4]

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.