Forum Discussion
Excel Number Format Denominations
I have a number format, ' mm:ss.00 ', which allows me to enter numbers in minutes, seconds and tenths and hundredths of seconds. This works fine, but when I have a time that's less than one minute, i...
CaveT170 No - Excel sees 12.34 as a number, not as a time, and formatted as a time, that number looks very different.
To make Excel convert 12.34 to 00:12.34 would require VBA code (and disable undo). That might be overkill. Do you really want that?
In that case, is there a way I can enter numbers with the ' 00: ' prefix, but have it be displayed without, and for numbers over a minute include the prefix, or is that the same issue?
- Thank you very much. This has worked great.