View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Automatic update of date once, then remains static

copy and paste special values

--
Don Guillett
SalesAid Software

"mfdc_frank" wrote in message
...
other fields need to be updated, this returns current date and time and
updates with every save... not good..!

"Marcelo" wrote:

=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