Forum Discussion
Solved
Fractions
Hi there. I'm trying to enter an improper fraction in my spreadsheet (e.g. 6/5) but Excel automatically changes it to 1 1/5. So, I have two questions: How do get Excel to display that as 6/5? Sec...
If the numerator and denominator will be one digit, apply the custom number format ?/?
If hey could be one or two digits, you can use the custom number format ??/??
If the numerator and denominator will be one digit, apply the custom number format ?/?
If hey could be one or two digits, you can use the custom number format ??/??
Thanks for the response but that didn't work for me. When I entered 6/5, it immediately changed it to 1 1/5. And when I looked at Format, it had been switched back to "Fraction" even though I had changed it to Custom as you suggested. Any thoughts?
What do you see in the attached sample workbook?