View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default 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