Thread: Date Stamp
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?