change to number format
 

I am new to the forum, so some help would be appreciated.

I have data in the form of 132 ' 30 which represents 132 30/32.

If someone could show me how to convert into the /32, I would appreciate it.,.


Thanks

AU

change to number format
 

=LEFT(A1,FIND("'",A1)-2)+RIGHT(A1,LEN(A1)-FIND("'",A1)-1)/32
--
David Biddulph

"aupeter" <u50243@uwe wrote in message news:92dd458bb78f2@uwe...
I am new to the forum, so some help would be appreciated.

I have data in the form of 132 ' 30 which represents 132 30/32.

If someone could show me how to convert into the /32, I would appreciate
it.,.


Thanks

AU

change to number format
 

Hi Aupeter,

Assuming that you have this data in Cell A1, use the following formula:-

=MID(A1,1,FIND("'",A1)-2)&""&RIGHT(A1,(LEN(A1)-FIND("'",A1)))&""&"/32"

Please click on "yes" if it helps..Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"aupeter" wrote:

I am new to the forum, so some help would be appreciated.

I have data in the form of 132 ' 30 which represents 132 30/32.

If someone could show me how to convert into the /32, I would appreciate it.,.


Thanks

AU