View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Stop Updating Today() On opening

hi,
=now() will always show the current date.
if you want to enter todays date and have it stay that way, use the keyboard
shortcut Ctrl+;

Regards
FSt1

"PWS" wrote:

Is there a way to have a workbook open, and have the Today() function
in a cell not update itself.

I have tried setting recalculation to manual prior to opening the
workbook and this does not achieve what I am looking for.

PWS