how to include real time & date on excel spread sheet
B Barb R. Mar 23, 2005 #2 I was supplied with a small macro that would enter the current date/time in a cell when invoked. Sub NOWTIME() ActiveCell.Value = Format(Now(), "mm-dd-yyyy h:mm:ss AM/PM") End Sub Is that what you want? Barb Reinhardt
I was supplied with a small macro that would enter the current date/time in a cell when invoked. Sub NOWTIME() ActiveCell.Value = Format(Now(), "mm-dd-yyyy h:mm:ss AM/PM") End Sub Is that what you want? Barb Reinhardt
