How to convert this text number and fraction to 1 figure usingmac
provided yr data always follows that same pattern you might also try a
formula:
=LEFT(A1,FIND(" ",A1)-1)+(LEFT(RIGHT(A1,FIND(" ",A1)-1),1)/RIGHT(RIGHT
(A1,FIND(" ",A1)-1),1))/100
On 14 Sty, 08:33, swiftcode
wrote:
Hi all,
I have this text in a number of cells typed in as e.g. ".09 1/4" which in
numeric terms is 0.0925.
My questions is, can someone please help me think of a simple macro to
automatically covert the cell to a numeric.
Many thanks in advance.
Ray
|