what function to use

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

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
 
use the following formula:

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

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

The result is only 000100000, could you explain more?
Thanks in advance
 
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
Click to expand...



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

--ron
 
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
Click to expand...


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

=TEXT(A1,"000100000")

--ron
 
Back
Top