Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating date from a Date & Time stamp | Excel Discussion (Misc queries) | |||
Date Stamp Need | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Date Stamp | Excel Discussion (Misc queries) |