Forum Discussion

Copper Contributor

Jun 13, 2025

Custom number formatting help

Hello, I need some help/advice for displaying a value. Im scaling large recipe amounts, and at some point it'll become cumbersome to do '112 tbsps' and I'd prefer it read '7cups' after a thresho...

developer

excel

Formulas and Functions

Office Scripts

SergeiBaklan

Diamond Contributor

Jun 14, 2025

Custom number formatting, as any other formatting, doesn't change the value in the cell. If it is 112, fraction format correctly shows that value as 1792/16.

Yes, with convert function like

=IF( A1 >= 32, CONVERT( A1, "tbs", "cup"), A1 )

where is another issue if you'd like to keep number in the cell, not texts. It's not clear how to define logic for custom number format for the result, e.g. if result is 2 it's not clear, that's spoons or cups.

Durbin

Copper Contributor

Jun 14, 2025

It seems as though that is my only way. And your explanation makes sense for the scaling. The reason I wanted to use the Number Format was so that the cell would stay the same value (112). There is a unit reference earlier in the recipe. The recipes scale into the thousands so its easier/better to keep the value consistent. For the sake of the user printing it out though I was hoping to display the next unit up ( qts to gallons, tbsp to cups, etc. ).

I appreciate the help and explanation!

Thanks