Software Development

A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format.

In the Q the user does not mention the locale settings, but did write "I've used the LEFT function to get just the number part, though that still leaves me with a string." Some sample data was provided, but not its location so assuming the following:

and , to separate thousands, . for decimal, how to determine the sum of the above text-format amounts?

is a duplicate

This question has been asked before and has already been answered. It should be marked as a duplicate.

Please enter the URL of the proposed duplicate in the details field below.

not constructive

This question cannot be answered in a way that is helpful to anyone. It's not possible to learn something from possible answers, except for the solution for the specific problem of the asker.

Communities

Comments on Summing values formatted for a different locale

Summing values formatted for a different locale

2 comment threads