csv file truncating zero values

J

JP

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top