This may do what you want, works for me. Go to Tools and select Auto Correct
Options and in the replace box enter . and the with box enter : and click
add. Now when you type 1.25 it enters as 1:25 and defaults format to time
automagically. When you're done select the rule you made and delete it.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"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
>
>
>