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!

Related Questions

How can I go back from YouTube TV to ‘normal’ Youtube

1  Asked on December 15, 2021 by user55949


Does Mailchimp notify for unsubscriptions?

1  Asked on December 8, 2021 by user54099


Why is @channel disabled in Slack threads?

2  Asked on December 8, 2021 by tgar


Remove upstream from forked repository on GitHub

2  Asked on December 6, 2021 by nathan-arthur


Search Twitter for Tweets Containing Polls

2  Asked on December 3, 2021 by elad-ratson


How can I delete a SINGLE article in pocket?

1  Asked on December 3, 2021 by jonny-bowden


How to search in the current slack channel?

2  Asked on December 3, 2021


How to Add RTL Tables to a Google Document

1  Asked on December 1, 2021 by azriel-lider


Ask a Question

Get help from others!

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