View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SGfla SGfla is offline
external usenet poster
 
Posts: 8
Default Can Excel automatically insert current date in a cell?

Thanks, Paul D. That helps!

"Paul D. Simon" wrote:

While neither a formula solution nor an automated method, simply doing
Ctrl+; (in other words, holding down the Ctrl key while hitting the
semi-colon) will enter the current date as a static (non-changing)
date into the active cell.