I'm wondering if there is a way to put a date stamp on cell data. I have a spreadsheet of client contact data that multiple people might update. Ideally I would like to be able to look at the data in the cell (like an address for instance) and have it also show the date on which the address was entered. That way, if a client gets a new address and one person update it, the others will know that it is current. And, if possible, I would like to have this function be enabled automatically - i.e. the person changing the data would not be responsible for entering the formula. Namely, they would just enter the information and the date stamp would be enabled automatically.
I'm using Windows 2000 and Excel 2000 if that makes a difference.
Any help will be appreciated!