Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Improper fraction format?
Greetings and TIA for your help...
If I format a cell as fraction and then enter =3/2 it will display as expected as 1 1/2. Is there any way to get it to display as 3/2 and retain it's properties as a value? -- David |
#2
|
|||
|
|||
David,
Custom format of ?/? will work that way. HTH, Bernie MS Excel MVP "David" wrote in message ... Greetings and TIA for your help... If I format a cell as fraction and then enter =3/2 it will display as expected as 1 1/2. Is there any way to get it to display as 3/2 and retain it's properties as a value? -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fraction format | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) | |||
How do you enter numbers in a fraction format ? (78/27) | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |