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



"Shadyhosta" wrote:

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?