Numbers

[FelixJMcG]

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. 

[#2]

@FelixJMcG 

That could be custom number format like

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

[#3]

@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.

[#4]

@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?  

[#5]

@Hans Vogelaar 

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

[#6 · Accepted solution]

@FelixJMcG 

Maybe try a custom number format of 0.0#

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.

[#7]

@JMB17 

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

[#8]

Glad to hear that worked for you.