Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(now) changes when opened how do keep it from changing in excel
I use (NOW) to insert the date and time on some of my spreadsheets but the
date and time changes every time I reopen the sheet, is there some way of having the date and time auto inserted without changing every time the sheet is opened up. My sheets need a beginning date and time but when reopened for addational input the date and time change and I need it to stay the same as when started |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
(now) changes when opened how do keep it from changing in excel
Hi Tankerman,
did you try to copy and paste special values, before save? hth regards from Brazil Marcelo "tankerman" escreveu: I use (NOW) to insert the date and time on some of my spreadsheets but the date and time changes every time I reopen the sheet, is there some way of having the date and time auto inserted without changing every time the sheet is opened up. My sheets need a beginning date and time but when reopened for addational input the date and time change and I need it to stay the same as when started |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
(now) changes when opened how do keep it from changing in excel
Put this code in the workbook's _Open event:
Private Sub Workbook_Open() If Worksheets("Sheet1").Range("A1") = "" Then Worksheets("Sheet1").Range("A1") = Now() End If End Sub Change the sheet name and cell address as needed for your workbook. You can find detailed instructions on how to get into the VB Editor and get to the workbook's code module he http://www.jlathamsite.com/Teach/WorkbookCode.htm "tankerman" wrote: I use (NOW) to insert the date and time on some of my spreadsheets but the date and time changes every time I reopen the sheet, is there some way of having the date and time auto inserted without changing every time the sheet is opened up. My sheets need a beginning date and time but when reopened for addational input the date and time change and I need it to stay the same as when started |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
(now) changes when opened how do keep it from changing in excel
Otherwise if you don't use paste special you have to enter this each time Current date and time Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+; unless you use a macro. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562797 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
(now) changes when opened how do keep it from changing in excel
Manually you can enter a static date by CTRL + ;
Static time by CTRL + SHIFT + ; Gord Dibben MS Excel MVP On Wed, 19 Jul 2006 04:34:01 -0700, tankerman wrote: I use (NOW) to insert the date and time on some of my spreadsheets but the date and time changes every time I reopen the sheet, is there some way of having the date and time auto inserted without changing every time the sheet is opened up. My sheets need a beginning date and time but when reopened for addational input the date and time change and I need it to stay the same as when started |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
unlocked cells in excel 2000 now locked when opened in 2003 why? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) | |||
Opening Excel after changing settings and add-ins | Excel Discussion (Misc queries) |