TIMESTAMP FORMULA

[Stross002]

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!

 

[Stross002]

I want it to read: "Last Updated: (current date) at (current time)"

 

[FSt1]

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