Thread: Convert Function key on Keypad

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

See

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

or

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

--
Kind regards,

Niek Otten

"Ron - Matrix Investigations"
<RonMatrixInvestigations@discussions.microsoft.com> wrote in message
news:B83A8419-F396-412F-B460-8AFFA8B5A32F@microsoft.com...
>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,

Thank You very much

"Niek Otten" wrote:

> See
>
> http://www.*****-blog.com/archives/2...imming-splits/
>
> or
>
> http://www.cpearson.com/excel/DateTimeEntry.htm
>
> --
> Kind regards,
>
> Niek Otten
>
> "Ron - Matrix Investigations"
> <RonMatrixInvestigations@discussions.microsoft.com> wrote in message
> news:B83A8419-F396-412F-B460-8AFFA8B5A32F@microsoft.com...
> >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
>
>
>