Time Stamp

[sunderland27]

is there a way to put a time stamp in a field that will not change everytime
you update the spreadsheet?

 

[Bob Phillips]

Ctrl-Shift-colon

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[sunderland27]

how about the date? could i activate the time stamp when a differnt field is
selected?

 

[Dave Peterson]

How about plopping the time stamp when the value is updated.

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html