Since the recent redesign the symbols were removed from my number row. I've tried digging through all the menus but can't figure out how to add them back.
Has anyone else figured out how to do this yet?
I'm not sure if there is a current bug with this or if this is a tale as old as time because I'm foolishly trying to use spreadsheets for times.
I'm trying to enter in some time values that are under an hour.
- If I type in something such as 5:04, it'll display as 5:04 but the formula bar lists it as 5:04:00 AM.
- If I click on More Formats and select mm:ss, 22:59 becomes just 59:00 and the formula bar thinks it's 10:59:00 PM. 58:04 becomes 04:00.
- If I click on More Formats > Custom Date and Time and go with [minutes]:[seconds], again it will think it's time of day despite me clearly indicating I wanted mm:ss seconds earlier.
I know I can switch to plain text to display the correct values, but I also want to use some color scale conditional formatting and possibly do some averaging or other formulas.
I know how to change the number formula in a cell, but it's absolutely not sticking. I've done searching on this topic and all results I saw were from years ago, so again I don't know if this is a new bug or not.