Don't re-open the *.csv file in Excel.

Open it in Notepad or similar.

Your zeros will be there.


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 16:58:00 -0700, GKW in GA
wrote:

That doesn't work, for CSV anyway. When you save the CSV file you get the
standard prompt that says it contains features not compatible with CSV. The
choices are YES, to save it as CSV omitting the incompatible features or NO
to save it in another format besides CSV (like .xls). If you select YES, then
when you return, the leading zeros have been removed.

What you said works for .xls but not .csv. I tried it before I ever created
this post.
Maybe I have an option set wrong or something.