Date Stamp
 

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?

Date Stamp
 

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


"Leon" wrote in message
...
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?

Date Stamp
 

See

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

In article ,
Leon wrote:

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?