Lorraine Calvey
May 07, 2018Copper Contributor
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).