View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Situmorang[_2_] Frank Situmorang[_2_] is offline
external usenet poster
 
Posts: 65
Default what function to use

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