Sep 19 2018 12:14 PM
Hello,
I want to custom my number format as
ss.00;
But when I input my time in my cell as seconds.hundreths, it returns nothing.
One way it worked was for me to input my time as minutes(0):seconds.hundreths.
Is there not a way for me to only enter the desired data, as seconds.hundreths? Bypassing the 0minutes:...
Also, I've seen in some custom fields the symbol @ at the end of it : what does that stands for?
Thank you.
Sep 20 2018 01:06 AM
Jul 20 2019 06:03 PM
Interestingly, the ss.00 notation works in the latest version of Office 365 (screenshot attached) - what version of Excel are you in?
The @ symbol is simply a text placeholder.
Check out more at www.sumproduct.com and www.sumproduct.com/thought for free file download examples.