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.

Thanks

Styves


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

00":"00":"00