Sample Header Ad - 728x90

Opening CSV in Numbers does not display decimal numbers correctly

4 votes
1 answer
975 views
Lets say I have following CSV file: 1.0;0.125;0.1253 Opening it in Numbers gives me: enter image description here Why are 1.0 and 0.1253 correctly presented as "1.0" and "0.1253", but "0.125" is presented as "125"? What do I have to do to get Numbers to display "0.125" correctly? --- Edit: My region and language settings are set to Europe/Germany.
Asked by kostrykin (201 rep)
Mar 29, 2023, 12:29 PM
Last activity: Mar 31, 2023, 07:39 AM