Jan

Posts: n/a

date/time

I'm using Excel 2003.

Is this possible?

If end user enters data in A1, can I add a date/time function that will
automatically be entered in cell B1, but not update when the date/time
changes or when the file is closed/opened? Using Today() or Now(), the
date/time in B1 updates when file is closed and then opened.

TIA

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
Date/time range based calculations	jim314	Excel Discussion (Misc queries)	1	April 28th 05 07:21 PM
Drop time in date/time field	Gail	Excel Worksheet Functions	1	March 21st 05 08:21 PM
Date/Time Macro	Michael Link	Excel Discussion (Misc queries)	6	February 15th 05 12:55 AM
How do i convert a number of seconds to a date/time?	Margo	Excel Worksheet Functions	2	January 5th 05 12:09 AM
Calculating date/time	Paul Martin	Excel Discussion (Misc queries)	1	December 7th 04 12:17 AM

All times are GMT +1. The time now is 10:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us