number to text- looping off zeros

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

using Excel 2003..I am converting numbers to text (char) using the text to
columns feature. But when I do, it lops off the precceding zeros (ie it
does not recognize the preceeding zeros as valid chars).

Was told that the text to column feature has the ablitiy to not lop off
preceeding zeros- but after spending hours goofing around with it a folowing
some cryptic advice, could not find anything that works.

I guess I could cancatanate afterwords... but that is very tough to do on a
data list of 30k entrys... with varible length numbers (txt).....

Any ideas?
 
In the 3rd screen of Text-to-columns (XL 2002, at least) you can select each
column and indicate how you want it treated....general, text, date, or skip.

Evidently you want the zeros to be part of the cell contents, instead of
displaying via number formatting. Select that column and check: Text.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top