CSV leading zeroes
 

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 dataget external dataimport text file, then select *.* (all files)
and open it from there, that will also trigger the text import wizard.

Regards,

Peo Sjoblom

"Tim_nol" wrote:

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.

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


Peo Sjoblom wrote:
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 dataget external dataimport text file, then select *.* (all
files)
and open it from there, that will also trigger the text import
wizard.

Regards,

Peo Sjoblom

"Tim_nol" wrote:

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.