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