How can I show the "create date" of an Excel worksheet in a cell?
S SVC Jan 20, 2006 #2 If you want to show a static date (does not change), type Ctrl + ; and Excel will insert the current date. To insert the current date and time, type Ctrl + ; then Ctrl + Shift + ; and, if necessary, apply the desired date/time formatting.
If you want to show a static date (does not change), type Ctrl + ; and Excel will insert the current date. To insert the current date and time, type Ctrl + ; then Ctrl + Shift + ; and, if necessary, apply the desired date/time formatting.
A Alan Fletcher Jan 20, 2006 #3 That is a great shortcut! What if I want to create a cell in a template that automatically fills with the create date?
That is a great shortcut! What if I want to create a cell in a template that automatically fills with the create date?
