I need to convert a number to text but I need it to be 5 position
With
A1: 100
Try this:
B1: =TEXT(A1,"00000")
Is that something you can work with?
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Mike L." wrote:
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
|