Forum Discussion
Desmond Beatty
Feb 10, 2018Copper Contributor
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
- SergeiBaklanDiamond Contributor
Hi Desmond,
You may apply custom format like ?/? instead of default one # ?/?
- Desmond BeattyCopper Contributor
Bingo! Thank you.