Try in A2: =TEXT(SUBSTITUTE(A1,"/",""),"000")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gregork" wrote in message
...
In Cell A1 I have two types of text: 5/3 or 15/2
In Cell A2 I want a formula that changes the A1 text to 053 or 152.
Cheers
GK
|