Thread
:
Leading Zero in .csv format
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Leading Zero in .csv format
Don't open the .csv file in excel to check it.
Use NotePad--or some other text editor.
You'll find that the leading zeros are there.
Excel will remove them when you reopen the .csv file--not when excel saves it.
wrote:
I've read all the post and blogs on csv files dropping leading zero's
and still haven't found a solution. I have Excel 2002 and when I save
file as .csv it drops the leading zero. I've tried formatting cells as
text before saving as csv, importing data with cells set as text,
under custom format my version of evcel doesn't have an option for
00000 or #0000. I was told that I need to upgrade to a newer version
of excel. Any help would be greatly appriciated..
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson