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 |
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 |
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 |
All times are GMT +1. The time now is 11:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com