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

DDUUUAAAHHH!!!! sorry didn't understand the 'copy and paste special' thanx!

"Don Guillett" wrote:

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