Thank you
I have had a look at all three suggestions. unfortunately VBA is a little
too advanced for me.
column a I would like to have current date and time when I open workbook and
then when I enter information in columns b c,d,e, etc then I would like
current date and time to come into next row in column a when I need to select
an item from a drop down box in column b. Is this possible for a new user or
is it a more advanced formula that needs vba


"David McRitchie" wrote:

To include both date and time in the same cell enter the shortcut
for the date then a space and then the shortcut for the time, and
it will be a legitimate Excel date and time.

More information on Date & Time in
http://www.mvps.org/dmcritchie/excel/datetime.htm
More information on keyboard shortcuts
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

If you want the timestamp entered automatically into an empty
cell when you fill in another cell see
http://www.mvps.org/dmcritchie/excel....htm#timestamp

And "bete" please don't use all caps or all lowercase as it makes
your post hard to read for those providing free help as well as
others who might also learn from your question. I've translated
for you. // David McRitchie, Microsoft MVP - Excel

"Paul B" wrote...
bete, Ctrl+; for date and Ctrl+shift+; for time

"bete" wrote ...
I want to use computer date and time in a cell in a worksheet but
I do not want it to change after a minute, I want it to stay as it was
first entered. Is this possible.