Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMESTAMP FORMULA
Hello,
I want to put in cell A1 when I updated my worksheet. I want it to read: "Last Updated: 4/15 at 1:04PM" Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMESTAMP FORMULA
I want it to read: "Last Updated: (current date) at (current time)"
"Stross002" wrote: Hello, I want to put in cell A1 when I updated my worksheet. I want it to read: "Last Updated: 4/15 at 1:04PM" Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIMESTAMP FORMULA
hi
there isn't a formula that will do this. you might do better to use a macro to insert the date/time. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("Sheet1").Range("A1").Value = _ "last Updated: " & Now End Sub change the sheet name above is needed. paste the above into the ThisWorkbook module. then each time you save the file, the date and time will automaticly be inserted into the sheet you name and cell A1. to install... press Alt+F11 to bring up the VB editor. far left, expand your project(file) expand excel objects. double click ThisWorkbook Paste the above into the code window(far right). close the VB editor, save the file. regards FSt1 "Stross002" wrote: I want it to read: "Last Updated: (current date) at (current time)" "Stross002" wrote: Hello, I want to put in cell A1 when I updated my worksheet. I want it to read: "Last Updated: 4/15 at 1:04PM" Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a Static Timestamp Formula | Excel Worksheet Functions | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
Excel formula timestamp for a data entry of a referenced cell | Excel Worksheet Functions |