automatically input date?

C

Chip Pearson

The formula

=TODAY()

will return the current date, and will update everytime the
workbook is calculated. If you want to insert today's date as a
constant value, one the will not change, press CTRL <semicolon> .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"djarcadian"
in message
news:[email protected]...
 
P

Peo Sjoblom

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
 
Top