| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format as an improper fraction
How do I format a number as an improper fraction; that is, 1 1/2 would show
as 3/2 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format as an improper fraction
How about a custom format of
##/## Mike "hmm" wrote: How do I format a number as an improper fraction; that is, 1 1/2 would show as 3/2 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format as an improper fraction
Works well Mike.
Can it also suppress the fraction format if the number is an integer (instead of 2/1, just 2). "Mike H" wrote: How about a custom format of ##/## Mike "hmm" wrote: How do I format a number as an improper fraction; that is, 1 1/2 would show as 3/2 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert fraction format to text format ...... | New Users to Excel | |||
| VBA won't format into fraction | Excel Discussion (Misc queries) | |||
| fraction format | 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
