I am new to Libre Office. I am trying to add up several numbers, some with decimal points and others without decimal points. It will only add up the numbers without decimal points. If I enter numbers with decimal points and press autosum, I get this =SUM()
I have tried changing it to General and then Numbers but it makes no difference. What am I doing wrong?
Most probably, the locale in LibreOffice (and probably that’s your locale) uses not a decimal dot, but a decimal comma. That would lead to “numbers with decimal dots” being not numbers, but strings (which look like numbers, but evaluate to 0). Using numpad decimal separator usually inserts the right separator character for your locale (Options→Language Settings→Languages→Decimal separator key→Same as locale setting controls that).
I was having the same issue and I didn’t realize I had to use a comma since my LibreOffice was set to French.
One clue is that if it’s a number it will align inside the cell on the right, but if it does not recognize it as a number (in my case it did that when I entered 2.1) it aligned on the left.
In my case I did not want to change the locale and so changing from . to , when entering decimal numbers made the sum formula work.
The decimal separator depends of the locales.
