Frederik:

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

--
H. Frank Situmorang


"Frederik" wrote:

use the following formula:

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

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

--
met vriendelijke groetjes

"Frank Situmorang" schreef in bericht
...
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



--
H. Frank Situmorang