Date Formatting

  • Thread starter Thread starter Parry
  • Start date Start date
Hi
Quick attempt, though I am sure you will get more detailed responses in due
course.
Assign a short cut key for a macro using the =Today() function, and format
as required
NB. will apply to active cell.
Mathew
 
Parry,

CTRL+; will insert the current date. CTLR+SHIFT+: will insert the
current time. These are entered as static text, meaning the values
will not update in the future.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top