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 |
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 |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com