CSV leading zeroes

[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.

 

[Guest]

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

 

[mixa]

just append an equal sign ("=")in front of the field you want leading
zeroes preserved.