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

Ctrl-Shift-colon

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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

"Bob Phillips" wrote:

Ctrl-Shift-colon

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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

sunderland27 wrote:

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

"Bob Phillips" wrote:

Ctrl-Shift-colon

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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




--

Dave Peterson