You would need an event macro

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Al Gillis" wrote in message
...
TIA for your help or reference links...

I've got a bunch of numbers (formatted as "general") I want to appear more
as time of day (no math needs to be done on these number)

For example, if my entries a
603
1851
720
1643
I want the resulting formated numbers to appear as:
06:03
18:51
07:20
16:43
(showing leading zeros where appropriate and colons)


Because these are just numbers I usually get results than look like dates
from early in the previous century!

Thanks!

Al