How to Display Leading Zeros in CSV file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
one of my applications is creating a CSV file from database but when that file is opened in Excel then some columns with actual values are 0020 are displayed as 20. How can I ask Excel to not truncate those leading zeros.

My users don't want to do anything on their side to fix this...They want the CSV file ready before they work on it.

Pls. help.
Thanx and Regards
 
Save the file as txt, open it with excel and the import text wizard will
start, in step 3 you can select
the column data format and if you select text the leading zeros will import

--

Regards,

Peo Sjoblom


Rajesh Puneyani said:
Hi All,
one of my applications is creating a CSV file from database but when that
Click to expand...
file is opened in Excel then some columns with actual values are 0020 are
displayed as 20. How can I ask Excel to not truncate those leading zeros.
My users don't want to do anything on their side to fix this...They want
Click to expand...
the CSV file ready before they work on it.
 
Back
Top