what function to use

[Frank Situmorang]

Hello,
This is my row that I want to convert from number to text but with certain
criteria:

A
1
2
..
..
..
12

to text to show it as follows

000100001
000100002
when number is 2 digits it should show
000100012
000100300

my number run upto 600

Please help us wahat function fo excel should we use, th forth character
sould always show 0001

Thanks in advance

 

[Frederik]

use the following formula:

="0001" & REPT("0",5- LEN(A1))&A1

supposing your data are starting in A1 en copy the formula down

 

[Don Guillett]

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

try format>custom
000100000

 

[Frank Situmorang]

Frederik:

The result is only 000100000, could you explain more?
Thanks in advance

 

[Ron Rosenfeld]

Hello,
This is my row that I want to convert from number to text but with certain
criteria:

A
1
2
.
.
.
12

to text to show it as follows

000100001
000100002
when number is 2 digits it should show
000100012
000100300

my number run upto 600

Please help us wahat function fo excel should we use, th forth character
sould always show 0001

Thanks in advance

=TEXT(A1,"""0001""00000")

--ron

 

[Ron Rosenfeld]

Hello,
This is my row that I want to convert from number to text but with certain
criteria:

A
1
2
.
.
.
12

to text to show it as follows

000100001
000100002
when number is 2 digits it should show
000100012
000100300

my number run upto 600

Please help us wahat function fo excel should we use, th forth character
sould always show 0001

Thanks in advance

Actually, this works just as well, and is simpler:

=TEXT(A1,"000100000")

--ron

 

[Frank Situmorang]

Frederik

You are awe some, it works perfecly, thank you very much