Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Function key on Keypad
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Function key on Keypad
Niek,
Thank You very much "Niek Otten" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numeric keypad | Excel Discussion (Misc queries) | |||
Custom Keypad | Excel Programming | |||
LAPTOP KEYPAD | Excel Discussion (Misc queries) | |||
Numeric Keypad | Excel Programming | |||
Decimal key on keypad is ignored | Excel Discussion (Misc queries) |