date/time stamp

[mzehr]

Hi,
See:
http://www.mcgimpsey.com/excel/timestamp.html

 

[Purple Youko]

When I want to use a date stamp in a spreadsheet report I always use
simple macro to do it. follow these steps.

1: Just place your "NOW" formula or "=today()" into a protected cel
somewhere away from the report section of your workbook. This will b
used as a reference since it will always update each day (as you hav
discovered)

2: Next click on the "record macro" button on your toolbar.

3: Name your macro and enter a shortcut key in the box provided the
click OK.

4: Select the cell with your "NOW" or "=today()" formula in it, righ
click the mouse and copy it.

5: Move to the cell where you want your date stamp to be and select it
Right click again and "paste special". Select "value" from the list.

6: Stop recording your macro.

You should now have a shortcut key such as ctrl-d (or whatever you se
the macro up with) which will place the current date into the correc
cell every time you press it

 

[Guest]

But if you use Ctrl-d you won't be able to fill down without using your
mouse....(not a big deal for everyone, I know).

Ctrl-; (semicolon) will insert the current date in a non updating format,
without recording a macro.

(Works in Access too!)