Thread
:
Adding zero prefix to no's
View Single Post
#
2
Max
Posts: n/a
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?
Reply With Quote