M
Mervyn Thomas
have some confusion with number formats in CSV files. Using a custom
number format 00000 I get numbers such as
00392 to display OK when on the screen when viewed in Excel but appears as
392 when the file is
repopened after saving.
The formats do appear OK in the saved file when opened with notepad.
However when the CSV file is
reopened in excel the number format is lost and appears as 392 rather than
00392. This also happens when the number is input as '00392 rather than
just using the custom format..
Can you explain what is happening here and what do you think external
systems will do with these numbers? Is there any way to maintain the 00000
formats?
Mervyn
number format 00000 I get numbers such as
00392 to display OK when on the screen when viewed in Excel but appears as
392 when the file is
repopened after saving.
The formats do appear OK in the saved file when opened with notepad.
However when the CSV file is
reopened in excel the number format is lost and appears as 392 rather than
00392. This also happens when the number is input as '00392 rather than
just using the custom format..
Can you explain what is happening here and what do you think external
systems will do with these numbers? Is there any way to maintain the 00000
formats?
Mervyn