Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing Date/Time after data entry.
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing Date/Time after data entry.
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Freezing Date/Time after data entry.
And yet another way would be to select the column(s), EditCopy, keep the
selection active or select the same columns again, and EditPaste 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. -- Y "CLR" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
Data Entry date/time? | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
data entry in excel by linking to other word doc. or excel sheets | Excel Worksheet Functions | |||
Simplified Data Entry | Excel Discussion (Misc queries) |