I need to convert a number to text but I need it to be 5 position

M

Mike L.

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
 
P

Peo Sjoblom

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
 
N

Niek Otten

=TEXT(A1,"00000")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
R

Ron Coderre

With
A1: 100

Try this:
B1: =TEXT(A1,"00000")

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top