Feb 15 2021 08:33 AM
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.
Feb 15 2021 08:45 AM
That could be custom number format like
but I'm not sure what is your entire formatting logic.
Feb 15 2021 08:48 AM
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.
Feb 15 2021 08:56 AM - edited Feb 15 2021 08:57 AM
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?
Feb 15 2021 08:58 AM
agreed...a lot of work to format each cell. And, I do want/need at least the SUM function
Feb 15 2021 10:13 AM - edited Feb 15 2021 10:16 AM
Solution
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.
Feb 15 2021 10:13 AM - edited Feb 15 2021 10:16 AM
Solution
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.