Forum Discussion

Desmond Beatty's avatar
Desmond Beatty
Copper Contributor
Feb 10, 2018
Solved

Display fractions like 100/30 and 3/2 as is and not 3 1/3 and 1 1/2

Can this be done in current Excel versions, if so how?   or does it require a feature enhancement?

  • Hi Desmond,

     

    You may apply custom format like ?/? instead of default one # ?/?

2 Replies