MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding Date and Time in Table

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

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.

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

There is a shortcut key for this;

Ctrl+; for date
Ctrl+: for time