View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

One way ..

Assuming the data is in A1 down

Put in B1:

=0&LEFT(A1,SEARCH("/",A1)-1)&"/"&0&MID(A1,SEARCH
("/",A1)+1,99)

Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Cheryl W" <Cheryl wrote in message
...
I have 500 cells typed as 1234567/1.
But I need them to read as 01234567/01
(8 digits at the beginning, but the first digit must be a zero - followed

by
a slash - followed by 2 digits).

Any suggestions how I can do this automatically?