Freezing Date/Time after data entry.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shadyhosta - 30 Jan 2007 18:04 GMT

If I want to make column A today's date, and column B Now, both of which
function I know how to do, is there a way to freeze these two columns when I
have entered data in, say, columns C through G so that I have an accurate
record of time and date as to when the data in the other columns was entered
that won't reset to today and now when I open up the spreadsheet again?

Reply to this Message

CLR - 30 Jan 2007 19:49 GMT

One way would be to enter the DATE by pressing Ctrl and hold while pressing
semicolon, and the TIME by Ctrl-Shift and colon.......these are permanent
values which will not change as the formulas =TODAY() and =NOW() do.

Another way would be to use a change-event macro to automatically enter the
date and time when you input values in another cell in the row......if this
is what you want, post back and somone will help........

hth
Vaya con Dios,
Chuck, CABGx3

> If I want to make column A today's date, and column B Now, both of which
> function I know how to do, is there a way to freeze these two columns when I
> have entered data in, say, columns C through G so that I have an accurate
> record of time and date as to when the data in the other columns was entered
> that won't reset to today and now when I open up the spreadsheet again?

Reply to this Message

Yacbo - 31 Jan 2007 06:24 GMT

And yet another way would be to select the column(s), Edit>Copy, keep the
selection active or select the same columns again, and Edit>Paste Special,
and under the "Paste Special" drop down menu, check the box which says
"Values" and click "OK". You are just telling Excel that you want the
formulas replaced with the current values...and these won't change when
"today" is no longer today but some past date.

Signature

> One way would be to enter the DATE by pressing Ctrl and hold while pressing
> semicolon, and the TIME by Ctrl-Shift and colon.......these are permanent
[quoted text clipped - 13 lines]
> > record of time and date as to when the data in the other columns was entered
> > that won't reset to today and now when I open up the spreadsheet again?

Reply to this Message