Exporting leading zeros

D

Dave Nagoda

I have a product that needs to import data from an ASCII
file. I get the data in an excel format and when I export
it the leading zeros go away. Example: 00000123456789
turns into 123456789. the program that I am importing
into needs these zeros. I have tried various ways around
this to no avail. Any suggestions?
 
F

Frank Kabel

Hi Dave
you may use a helper column with the following formula
=TEXT(A1,"00000000000000")
copy this for all rows and export this column
 
D

Dave N

What does this do? The number of zeros very from none to
many. Does this note the number of zeros and put that nin
the helper column?

Much Thanks
David Nagoda
Tucson, AZ USA
 
F

Frank Kabel

Hi
this just formats the number with leading zeros and returns them as a
string. Just test it :)
 
Top