ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   (now) changes when opened how do keep it from changing in excel (https://www.excelbanter.com/excel-discussion-misc-queries/100071-now-changes-when-opened-how-do-keep-changing-excel.html)

tankerman

(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

Marcelo

(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


JLatham

(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


VBA Noob

(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


Gord Dibben

(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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com