Change text to date
How about using excel's built-in shortcut:
ctrl-;
(ctrl-semicolon)
(I think it would be quicker.)
ctrl-: (ctrl-colon) will enter the time
Chey wrote:
I want to be able to type "X" into a cell, and when I hit enter I want it to
change to today's date. I can not do
--
Dave Peterson
|