In the csv downloads, numbers are formatted to use a comma as a thousand separator, and my Excel (on European settings, so with a decimal comma and a dot as a thousands separator) this gives trouble: a number like "12,340" will be read as "12,34" and changing the comma to a dot results in 1234 instead of 12340.
I suppose this would be easily solved by removing number formatting.
Changing the number format does not work, my excel does not recognize a string with two commas in there as a number at all, so it does not allow to change the number format. With currency it is even worse: the csv will give me something like "11,494,320 EUR". There is no way any excel would ever translate this to a number.
The only workaround I have found is replacing the commas by dots (being my 1000-delimiter) with control-V and replacing " EUR" with nothing. But that is nog very elegant and goes wrong with figures ending on 0 (since "15,720" is read as "15,72".)
M!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.