Date Stamp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leon - 12 Sep 2007 10:12 GMT

Hi there

I have made a DateStamp using this formula:

=TEXT(TODAY(),"d/mm/yyyy")

But when i go back to the work sheet the next day it a automatically
cahanges the date. Is there any way to stop the automatic update so the date
will remain the same?

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Sep 2007 10:27 GMT

The TODAY function, as well as the NOW function, do what they say... produce
today's (or now's) date... if the date changes, then the functions return
the then today or now date. If you want to place a date-stamp in a cell,
just select the cell and press Ctrl+; (that is the Control Key coupled with
the Semi-Colon Key). If you want to put a time-stamp in a cell, press
Ctrl+Shift+; (Control and Shift coupled with the Semi-Colon Key).

Rick

> Hi there
>
[quoted text clipped - 6 lines]
> date
> will remain the same?

Reply to this Message

JE McGimpsey - 12 Sep 2007 14:07 GMT

See

http://www.mcgimpsey.com/excel/timestamp.html

> Hi there
>
[quoted text clipped - 5 lines]
> cahanges the date. Is there any way to stop the automatic update so the date
> will remain the same?

Reply to this Message