LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Permanent Date/time entery

Hi all

i am wondering if there is any way to be able to get a date into the cell
automatically but it stay as it is without being updated after closing and
reopening the file. what i mean is that i want to put some data in one cell
and the other cell shows the date of entery automatically, this part is easy
we can use now() function or even date and so on but the problem is that
these functions get updated (i.e when i come back the next day to the file
what i see is the date of the new day , now is there any way that excel keep
the first date he got from the function as it is ?

that would be a great help indeed.
thanks in advance
M.M
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date is not permanent paintbrush New Users to Excel 2 November 12th 09 03:36 PM
change =NOW() to permanent date string [email protected] Excel Programming 4 June 22nd 07 03:33 PM
permanent time and date stamp for Excel --- so it cant be changed TR clvgis Excel Discussion (Misc queries) 1 December 30th 06 01:23 AM
Date format in permanent list kayabob Excel Discussion (Misc queries) 1 October 14th 06 09:35 AM
Set Permanent Date Format to MM//DD/YYYY kayabob Excel Discussion (Misc queries) 1 July 7th 06 04:46 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"