Forum Discussion
Fractions
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?
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).
