Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |