Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Adding Date and Time in Table

Posted by Amir on November 18, 2001 12:04 AM

Hi,
Can anyone tell me how to add a shortcut ("cookie") in the toolbar that enables me to add the current date and/or time in a cell in a table.
Thanks,
Amir

Re: Adding Date and Time in Table

Posted by Bill on November 18, 2001 3:28 AM

There is a shortcut key for this;

Ctrl+; for date
Ctrl+: for time

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.