ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fractions (https://www.excelbanter.com/excel-discussion-misc-queries/97757-fractions.html)

phil2006

Fractions
 

I want my fractions to have a format such as 7/5, 10/3 5/1etc. I don't
want 1 2/5, 3 1/3, 5... as I have been getting. Is this possible?

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=558795


[email protected]

Fractions
 
Hello,

Goto Format / Cells / Custom and enter type #?/#?

HTH,
Bernd



All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com