Forum Discussion
Thomas Littzen
Sep 19, 2018Copper Contributor
Input style in custom number formatted cell seconds.milliseconds possible?
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(...
Liam Bastick
Jul 21, 2019MVP
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.