View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Automatic update of date once, then remains static

=now()

copy and paste special values

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"mfdc_frank" escreveu:

Help!! need to automatic update cell with current date, then freeze cell from
further updates. thanx in advance.. Frank