Thread: =now()
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default =now()

You'll have to "copy and paste special / values" the NOW() once it is
entered. You can either do that manually or use a macro (Workbook open event
may work) is up to you.

"Jim" wrote:

Hello,

How do (is there a way) to write = NOW( ) so that the date will become
static once the Excel sheet is opened?