w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Within excel 2010 how can I convert text formatted number ###### into time formatted as mm:ss.00

The ###### could simply mean your column widths are too small. Try expanding them and see if that works. Otherwise, you can modify the format (cell data type) by simply right clicking it and selecting "Format cells...". From there, you can select the "Time" format or create your own in the "Custom" format, both located under category.

If you always want the milliseconds to be "00", you may want the custom format mm:ss:"00"





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.