software

Hello,

How do (is there a way) to write = NOW( ) so that the date will become
static once the Excel sheet is opened?You'll have to quot;copy and paste special / valuesquot; the NOW() once it is
entered. You can either do that manually or use a macro (Workbook open event
may work) is up to you.

quot;Jimquot; wrote:

gt; Hello,
gt;
gt; How do (is there a way) to write = NOW( ) so that the date will become
gt; static once the Excel sheet is opened?
gt;

Check out

www.mcgimpsey.com/excel/timestamp.html

In article gt;,
Jim gt; wrote:

gt; Hello,
gt;
gt; How do (is there a way) to write = NOW( ) so that the date will become
gt; static once the Excel sheet is opened?

Insert a static date or time
Current date Select a cell and press CTRL ;

Current time Select a cell and press CTRL SHIFT ;

Current date and time Select a cell and press CTRL ; then SPACE then
CTRL SHIFT ;--
paul
remove nospam for email addy!
quot;Jimquot; wrote:

gt; Hello,
gt;
gt; How do (is there a way) to write = NOW( ) so that the date will become
gt; static once the Excel sheet is opened?
gt;