Jun 30 2021 12:05 AM
Hello Community,
I have downloaded an excel file from Visma (accounting software) in csv format.
Excel does not recognize the numbers as such and does not even show any error warning (normally you get the small green rectangle in the upper left corner of the cell).
The following trials all failed:
- use "paste special" with add or multiply
- use =value formula
- use "Data" - "Text to Columns" "Fixed with" "Finish"
- change the format from "general" to number
- converted csv to xlsx via an online converter
Please find attached the file. Is there anybody who knows the redeeming solution?
Kind regards,
Ann
Jun 30 2021 12:13 AM
Solution
I found the solution with a colleague: I need to replace points and comma for decimals and thousands. We work with the American decimal system not with the European system :D
Jun 30 2021 12:13 AM
Solution
I found the solution with a colleague: I need to replace points and comma for decimals and thousands. We work with the American decimal system not with the European system :D