View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP[_15_] JP[_15_] is offline
external usenet poster
 
Posts: 2
Default csv file truncating zero values

When I open a csv file and change contents on the first row via excel,
numbers such as 000999 are saved as 999. I need to change column headings
on the first row of my csv file and save it while preserving the number
formatting below it. Can this be accomplished using the Write or Print
statement via vba? At present, I am opening it and saving it with Excel.