MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Format

Posted by Styves on June 07, 2001 8:52 AM

Is it possible to format a cell so that if I enter 112555
as a string of number, it will return 11:25:55.

I don't want to enter the :

The solution is probably simple but I can't find it.



Posted by Mark W. on June 07, 2001 8:57 AM