| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I have excel convert fractions to decimals?
Sorry, I missed out the leading integers.
=LEFT(A1,FIND(" ",A1)-1) &"."& MID(A1,FIND(" ",A1)+1,find("/",A1),1) /MID(A1,FIND("/",A1)+1,255) &" x " & LEFT(B1,FIND(" ",B1)-1) &"."&MID(B1,FIND(" ",B1)+1,find("/",B1),1) /MID(B1,FIND("/",B1)+1,255) -- Regards Roger Govier "pgail" wrote in message ... I am typing in measuments of packages - i.e. 16 3/8 X 5 1/8, I want excel to convert to decimal. I have tried format cells, and convert, neither have this option available. "Ron Coderre" wrote: Can you give examples of how you need to deal with the fractions? Are you typing them? Are they in data that was imported? Are you referring to them in another cell? What have you tried? What were you hoping for? What were the actual results? *********** Regards, Ron XL2002, WinXP "pgail" wrote: 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
