See

http://www.dicks-blog.com/archives/2...imming-splits/

or

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

--
Kind regards,

Niek Otten

"Ron - Matrix Investigations"
wrote in message
...
I would like to assign a function key on my kaypad to convert a number into
a
time number - ie; enter 2330 on key pad and have it converted to 23:30 in
excel

Basically, I want to stay on the keypad without having to enter the ":"
key