On Thu, 29 Jan 2009 08:12:02 -0800, Frank Situmorang
wrote:

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