View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam_needs_help Adam_needs_help is offline
external usenet poster
 
Posts: 19
Default Can the way Excel default opens a *.csv be changed?

I don't want excel to assume every entry should be formatted as "general" but
rather as "text" so I don't loose any leading zeros in number i have stored
in a text file. Its annoying to have to use the wizard each time and change
the column types. I have a lot of files to open. I guess I could record and
use a macro to do it, but that might be a mess.

Let me know if there is a way to do this, thanks.