Open csv file with all values as text
Hi,
When excel opens my csv file, the numbers in it are automatically
changed to actual numbers, when I want them displayed as text/strings.
The problem with this is that, i.e my string "00500" is changed to the
value 500 when the file is opened, and will remain as 500 when the
file is saved again.
Does someone have some code which will prompt the user to select a csv
file, then open the file with all values as text/strings??
Cheers
Tony
|