Exporting leading zeros

  • Thread starter Thread starter Dave Nagoda
  • Start date Start date
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?
 
Hi Dave
you may use a helper column with the following formula
=TEXT(A1,"00000000000000")
copy this for all rows and export this column
 
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
 
Hi
this just formats the number with leading zeros and returns them as a
string. Just test it :-)
 
Back
Top