CSV leading zeroes

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

Guest

I have an app that exports data as CSV. Certain fields contain leading
zeroes. When the CSV is opened in Excel the Leading Zeroes are dropped. I
do not want to have any manual intervention. Is there a way to change a
setting in Excel to treat fields with leading zeroes as text and preserve the
fields as is.

Thanks.
 
You would need either to rename it to *.txt, that will trigger the text
import wizard where you can select the import as text and keep leading zeroes
or use data>get external data>import text file, then select *.* (all files)
and open it from there, that will also trigger the text import wizard.

Regards,

Peo Sjoblom
 
Back
Top