Posted to microsoft.public.excel.misc

Jason Southco

Posts: n/a

Enter Static Date with a formula or macro

Is it possible to enter a static date with out using ctrl + ;. I want to be
able to have the date automatically generate when the user enters data in a
field and not have the date change when the system date changes.

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
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
Formula for If Term is on Certain Date then Count	Krisjhn	Excel Worksheet Functions	3	August 30th 05 07:57 PM
Date formula	Sussex	Excel Worksheet Functions	2	February 22nd 05 10:07 PM
Can you enter a formula in a cell to run a macro?	Nevaeh	Excel Worksheet Functions	2	February 14th 05 11:51 PM
Macro Formula revision?	Mark	Excel Worksheet Functions	1	November 28th 04 01:43 AM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us