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, but that didn't work for me. It still changes 6/5 to 1 1/5 and then when I look at the formatting, it has reverted back to "Fraction" even though I selected "?/?" as you suggested (numerator and denominator will always be one digit).