Stop fractions from showing as lowest common

[northernguy]

How do I stop 6/18 from reducing to 1/3, even though it's formatted to two digits.

 

[mole999]

not sure you can 6/18 ths is one third

unless you mean you can use it as text, in which case '6/18 will fix it for you

 

[GTO]

If the denominator is to be 18, you could use '# ??/18' as a custom number format (dicth the single quotes).

 

[northernguy]

Thanks! This works.

If the denominator is to be 18, you could use '# ??/18' as a custom number format (dicth the single quotes).