ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Entering and displaying fractions (https://www.excelbanter.com/excel-worksheet-functions/76158-entering-displaying-fractions.html)

Chris Price

Entering and displaying fractions
 
I want to enter and display a fraction as 4/52, but this is converted to
1/13. Is there a way I can avoid Excel converting?
--
Chris Price

Bob Phillips

Entering and displaying fractions
 
It will reduce unless you specify the denominator in the format, such as
#?/52

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Chris Price" wrote in message
...
I want to enter and display a fraction as 4/52, but this is converted to
1/13. Is there a way I can avoid Excel converting?
--
Chris Price





All times are GMT +1. The time now is 11:40 PM.

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