microsoft.public.windowsxp.customize

No mapping is needed. Just enter the four digits. Say in column A we have
entered:
2341
In B1 put:
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
format B1 as hh:mm and copy down

Saving a keystroke make the entry process easier.
--
Gary''s Student - gsnu2007e


"Thomas G. Marshall" wrote:

> I need to enter a number of times a time of this form into an Excel
> spreadsheet:
>
> HH:MM
>
> And I would like to use my USB numberpad with my notebook to do this. I
> would like to remap the number pad's "." key to be a ":" instead.
>
> I have KeyTweak, and also know other ways of remapping the KEY, but this
> would only do this mapping:
>
> Numpad "." ---> ";"
>
> (requiring the shift to gain the colon.)
>
> Is there any way for me to map
>
> Numpad"." ---> ":"
>
> ?
>
> Thanks
>
>
>