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).