software

I am creating a log sheet. I need the date and time to automatically enter in
cell b2 when text is entered in a2. However, once that time is entered, I do
not want it to update next time I open the document. Currently, I am using
the NOW function, but it updates everytime I open the document. If I go to
tools, options, calculatons, I can change when Excel updates. However, I need
it to update everytime I open the file, because there are other formulas in
the document that must be updated.

Any help would be greatly appreciated.

www.mcgimpsey.com/excel/timestamp.html

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;sklomstadquot; gt; wrote in message
...
gt;I am creating a log sheet. I need the date and time to automatically enter
gt;in
gt; cell b2 when text is entered in a2. However, once that time is entered, I
gt; do
gt; not want it to update next time I open the document. Currently, I am using
gt; the NOW function, but it updates everytime I open the document. If I go to
gt; tools, options, calculatons, I can change when Excel updates. However, I
gt; need
gt; it to update everytime I open the file, because there are other formulas
gt; in
gt; the document that must be updated.
gt;
gt; Any help would be greatly appreciated.