timestamp
excell spreadsheet, cell acquires date from formula, but when new information
is entered the date changes, I need it not to change once the formula has been made. |
timestamp
On Sun, 17 May 2009 07:01:12 -0700, james
wrote: excell spreadsheet, cell acquires date from formula, but when new information is entered the date changes, I need it not to change once the formula has been made. Tie it to the file creation date. This query would then be about how one extracts such file attribute info during a session for use in a sheet. |
timestamp
I would suggest some type of event code that adds a static timestamp rather
than have a formula-derived one. But you can prevent a formula from updating using worksheet functions alone. Couple of methods on John McGimpsey's site One without VBA and one with. http://www.mcgimpsey.com/excel/timestamp.html Gord Dibben MS Excel MVP On Sun, 17 May 2009 07:01:12 -0700, james wrote: excell spreadsheet, cell acquires date from formula, but when new information is entered the date changes, I need it not to change once the formula has been made. |
All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com