Use a help column and a formula

=TEXT(A1,"00000")

where A1 holds 100, after you are done copying the formula, then select all
formula results and copy them, then paste special as values in place


--
Regards,

Peo Sjoblom


"Mike L." <Mike wrote in message
...
I need to convert a number to text but it needs to be 5 positions. For
example of the number is 100, I need the text value to be 00100.

Any Ideas