Automatic update of date once, then remains static

M

mfdc_frank

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

Marcelo

=now()

copy and paste special values

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



"mfdc_frank" escreveu:
 
M

mfdc_frank

other fields need to be updated, this returns current date and time and
updates with every save... not good..!
 
G

Gord Dibben

Frank

CTRL + ;(semi-colon) to insert a static date.

Forget the copy/paste special.


Gord Dibben MS Excel MVP
 
Top