Posted to microsoft.public.excel.worksheet.functions

Lp12

Posts: n/a

Now formula problem

Hi All,
I want to create a timestamp in A2 cell if there is a value in A1.
I used the Now() function which worked great, but each time i save the
worksheet, the timestamp cell (with the Now formula) changes to the current
date/time.
Is there an alternative to accomplish a stable date-time stamp that will
change only if the user accessed and changed A1?
Thanks a lot in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula percentage problem	thinkpic	New Users to Excel	4	November 2nd 05 08:04 PM
formula problem	Bart	New Users to Excel	4	October 21st 05 12:56 PM
problem with Array Formula	OrdOff	Excel Worksheet Functions	2	June 30th 05 04:57 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Baffling formula problem	Ken Schmidt	Excel Discussion (Misc queries)	2	December 21st 04 07:52 AM

All times are GMT +1. The time now is 11:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us