Convert Function key on Keypad

[Guest]

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

 

[Niek Otten]

See

http://www.dicks-blog.com/archives/2006/02/10/recording-swimming-splits/

or

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

--
Kind regards,

Niek Otten

"Ron - Matrix Investigations"

 

[Guest]

Niek,

Thank You very much

See

http://www.dicks-blog.com/archives/2006/02/10/recording-swimming-splits/

or

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

--
Kind regards,

Niek Otten

"Ron - Matrix Investigations"