I seem to recall a way to "time stamp" an entry........in other words, the date and time of an entry into a cell can be added to a row, then "locked"; useful for timekeeping, dating data entries, etc.

Anyone know how to do this?

Control + semicolon puts a date stamp

Control + shft + semicolon puts time stamp

or enter this as a cell formula

" =NOW () "

I'm actually using the "Open Office" version at home, and the ctrl-semicolon function does not work.

The NOW function works, but updates to current time every time the sheet is opened.

I'm actually using the "Open Office" version at home, and the ctrl-semicolon function does not work.

The NOW function works, but updates to current time every time the sheet is opened.

1. Press [Ctrl][F3].

2. Enter DateStamp in the Names In Workbook text box.

3. In the Refers To text box, enter the following formula:

=TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM")

4. Click the Add button and then click OK.

Now you can add a time and date stamp to every worksheet in your workbook by typing =DateStamp in any cell.

Boofa -

You just solved a problem I've been working on. Thank you sir. I thought I was an excel god, but I bow to you.