| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I have excel convert fractions to decimals?
Hi
If the cell is formatted as fraction, just FormatCellsGeneral or if you want to retain both, assuming the fraction is in A1 then in another cell =A1 and format that cell as General. If the fraction has been entered as text in a cell then =LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,255) -- Regards Roger Govier "pgail" wrote in message ... I am trying to convert fractions to decimals |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert CSV File Into Formatted Excel Document | Excel Discussion (Misc queries) | |||
| WordPad file convert in Excel | Excel Discussion (Misc queries) | |||
| How can I convert an Excel file to an Adobe .pdf file by using Ex. | Excel Discussion (Misc queries) | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| How do I convert decimal inches to fractions in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
