| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fraction in 16ths format reduced to LCD
I have size data given in millimeters and converting it into inches in 16ths
fraction format. How do I reduce resulting fractions to lowest term - I don't want to see 8/16 but do want 1/2. |
|
#2
|
|||
|
|||
|
Format CellsNumberCustom
In the Type box, enter # ??/?? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Derek" wrote in message ... I have size data given in millimeters and converting it into inches in 16ths fraction format. How do I reduce resulting fractions to lowest term - I don't want to see 8/16 but do want 1/2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fractions in 16ths format - reducing to LCD | Excel Discussion (Misc queries) | |||
| fraction format | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| Improper fraction format? | Excel Worksheet Functions | |||
| How do you enter numbers in a fraction format ? (78/27) | Excel Discussion (Misc queries) | |||
Linear Mode
