Simplify fractional result of custom number format
Web Applications Asked by fred on September 16, 2020
In Google Sheets I would like to express any decimal number to the nearest 32nd of an inch. If I type 1.537 I want the result to be 1 17/32, but if I type 1.5 I need it to be expressed as 1 1/2 not 1 16/32 nor 48/32, is there a way to achieve this?
One Answer
With # ??/32 you are locking it only to "/32" fractions. For variable fractions you need to use:
#??/??
Answered by user0 on September 16, 2020
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- haakon.io on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Peter Machado on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?