View Single Post
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Lisa,

It probably isn't dropping the zeroes when it writes the csv file, but when
you reopen it with Excel. Go to www.smokeylake.com/excel. Go to "Very
Frequently Asked Questions (VFAQ)" and look at "TEXT FILE -- SAVING -- DATA
GETS CHANGED."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Lisa" wrote in message
...
I have programs that only import the csv format. When I create the file
with
a text field using number such as 0101, 0321 if I close and reopen the
file
it drops the zero. How do I correct this?