| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need formula which convert figure in to text | Excel Worksheet Functions | |||
| i need formula which convert figure in to text | Excel Worksheet Functions | |||
| Take fraction out of the figure | Excel Worksheet Functions | |||
| how to convert numerical figure into text | Excel Worksheet Functions | |||
| How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
Threaded Mode
