Hi

Typing Control + semicolon (ctrl ;) will enter today's Date into a cell
as a fixed value.
Typing Control + Shift + semicolon (ctrl :) will enter Current Time into
a cell as a fixed value.

The following Macro will place the value of NOW() in the active cell as
a fixed value

Sub Timestamp()
ActiveCell.FormulaR1C1 = Now()

End Sub


You can copy the code and paste it into your Visual Basic Editor
(VBE) in a Standard Module located in your file.

To do this,

Alt + F11 (open VBE)
Ctrl + R (open Project Explorer)
Select the file name on the left
Insert Module
Paste code in Module

To run the macro, ToolsMacroMacrosSelect the macroRun.

If you want to create a shortcut, then ToolsMacrosSelect the
macroOptionsenter a key to use with CtrlOK


If you are new to entering macros, then David McRitchie has lots of
useful help on his site at
http://www.mvps.org/dmcritchie/excel/install.htm
http://www.mvps.org/dmcritchie/excel/getstarted.htm



--
Regards

Roger Govier


"The Fool on the Hill"
wrote in message
...
Dear excel(lent) users

I have an actionlist in Excel with a couple of formulas which make it
easier
to fill in the specific details.

When I enter something in field B2 a couple of other fields are filled
out
automatically by these formula´s, such as the number of the action, or
the
date of today. And this is were my question arises.

I have used the following formula:
=if(B2<"";now();"")

The problem is with using now(), that it always fills in the actual
date of
today. Meaning tomorrow now() is today+1. So if I look at the sheet
tomorrow
it seems that I entered todays activity tomorrow instead of today.

Is there a way to avoid this from happening in a simple way??

Thanks kindly for helping me out in this matter.

Kind regards,

Jay