=TEXT(A1,"00000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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