SOLVED

Numbers

New Contributor

I want to be able to have a number like "1.0"...and "1.75". I can't figure out how to do that without it making it "1" or "1.00". I can get "1.0"....but, it then changes "1.75" to "1.8" etc., etc. 

7 Replies

@FelixJMcG 

That could be custom number format like

image.png

but I'm not sure what is your entire formatting logic.

 

@FelixJMcG 

If you need the numbers for calculations, you'd have to format each cell individually the way you want - not an attractive idea.

If not, you could format the relevant cells as Text. The cell value will then be exactly what you enter. But functions such as SUM and AVERAGE will ignore the values.

@Sergei Baklan 

 

I am keeping track of time in 1/4 of an hour increments. So, I like for one hour to look like:  1.0  And, an hour and fifteen minutes to look like:  1.25   But, I don't like the extra "0" of  1.00  or 1.50  Does that make sense?  

 

@Hans Vogelaar 

 

agreed...a lot of work to format each cell. And, I do want/need at least the  SUM function

best response confirmed by FelixJMcG (New Contributor)
Solution

@FelixJMcG 

 

Maybe try a custom number format of 0.0#

 

JMB17_0-1613412607771.png

 

Or, if you want the decimals to line up, I think you could use 0.0?

Note: the "?" is part of the number format and intended to be punctuation.

 

JMB17_0-1613412919238.png

 

@JMB17 

 

THAT DID IT, JMB!!!  Thank you.....and, everyone else!  

Glad to hear that worked for you.