View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ed[_31_] Ed[_31_] is offline
external usenet poster
 
Posts: 34
Default Leading Zero in .csv format

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