Rename the .csv file to .txt
When you do file|open, you'll be prompted in the text to columns wizard on how
each field should be treated. You can choose text for the fields that should
retain the leading 0's.
Alternatively, you could use:
Data|Import External data (xl2003 menu system) and follow that wizard.
Ed wrote:
Dave,
I'm having the same problem. Is there any way to make Excel open the
.csv file containing a
string of numeric characters with a leading 0, e.g., "03" , and have
it saved in a cell as text instead of
numeric?
TIA
Ed
"Dave Peterson" wrote in message
...
I would think it would depend on how your database importing works.
wrote:
<<snipped
Okay, If I open the csv the zero is gone. If I open the file in
notepad the zero is present. Does that mean if I upload the csv
file
to my database that the number will be whole and the zero present?
Thanks Dave..
--
Dave Peterson
--
Dave Peterson