[Solved] How to sum numbers with "." and "," correctly

Discuss the spreadsheet application
Post Reply
oli007
Posts: 4
Joined: Fri Mar 26, 2021 12:27 pm

[Solved] How to sum numbers with "." and "," correctly

Post by oli007 »

hi there! i have a calc file with positions incl. "." and ",". i simply want to sum them, but cals doesnt show the correct sum because it probably gets mixed up with the dots and commas.

i want to sum these 2 amounts:

742.51 (this is 742,51 euro)
1,445.00 (this should be 1445,00 euro)
800.00 (this should be 800,- euro)

there always appears "0"
___________

if i sum e.g. these numbers:
5,89
6,01
2,01
-----
13,91
it works

please can you tell me how to solve this ?

thank you,
oli
Last edited by MrProgrammer on Mon Apr 05, 2021 4:33 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
open office 4.1.8
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: how to sum numbers with "." and "," correctly

Post by Villeroy »

When you import those data into a spreadsheet (you don't type them in), choose "English" as import language.
Choose "English (USA)" If there are dates like 12/31/2020.
Choose any other English If there are dates like 31/12/2020.
Always check option "Detect special numbers"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply