Automatic update of date once, then remains static

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

copy and paste special values

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



"mfdc_frank" escreveu:
 
other fields need to be updated, this returns current date and time and
updates with every save... not good..!
 
DDUUUAAAHHH!!!! sorry didn't understand the 'copy and paste special' thanx!
 
Frank

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

Forget the copy/paste special.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert date, but keep static on archived 4
First, Last occurance of date in column 5
Fixing date of entry 14
Date function 11
Excel Vba to change displayed year automatically. 14
Excel formula to incrementally increase a value by 1 every 365 day 2
Dates 4
want to track time while paste value in multiple column of same roe 1

Back
Top