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!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP