View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swiftcode swiftcode is offline
external usenet poster
 
Posts: 36
Default How to convert this text number and fraction to 1 figure using mac

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