a question regarding cell format
When you go through the text import wizard, in the last dialog, there is an
option to tell excel how to treat each column. You can specify that the
column be treated as Text.
--
Regards,
Tom Ogilvy
"Kelie" wrote in message
oups.com...
Hello,
Quite often I create tab-separated text file and open it in Excel. The
first column is usually "001", "002", "003", etc.. The problem is Excel
always automatically change them to "1", "2", "3", etc. which gives me
trouble. I've been looking in Excel trying to figure out how to
disable it but so far no luck. I realize this is not really a
programming question, but this is the group I visit about Excel.
Thanks in advance for any help.
Kelie
|