If you open that .csv file in notepad, do you see the leading 0's?
Excel will drop those leading 0's if you reopen the file in excel. That might
not be a problem--depending on what you're doing with that .csv file.
Joe wrote:
I have a column in the excel sheet that is of the in this format- 00001234,
But when I am saving it in the CSV format it does not show the leading zeroes
for some reason. Can anyone please tell me if there is a way to keep those
leading zeroes.
Thank you
--
Dave Peterson
|