View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default automatically input date?

Ctrl + ;

if you want to enter the time you would use

Ctrl + :

+ does not mean entering the plus sign it mean you hit Ctrl plus the
semicolon

you can also use formulas

=TODAY()

=NOW()

the formulas will change, then keyboard shortcuts will not

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"djarcadian" wrote
in message ...

How can I automatically input the days date in a cell?


--
djarcadian
------------------------------------------------------------------------
djarcadian's Profile:
http://www.excelforum.com/member.php...o&userid=15877
View this thread: http://www.excelforum.com/showthread...hreadid=549594