how do i enter date and time in cell without it changing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bete - 24 Mar 2007 02:03 GMT

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.

Reply to this Message

Paul B - 24 Mar 2007 02:20 GMT

bete, Ctrl+; for date and Ctrl+shift+; for time

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> 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.

Reply to this Message

bete - 24 Mar 2007 02:43 GMT

iS THERE ANYWAY TO HAVE THIS AS A FORMULAE ?

> bete, Ctrl+; for date and Ctrl+shift+; for time
>
> > 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.

Reply to this Message

David McRitchie - 24 Mar 2007 02:47 GMT

No, because you did not want the timestamp to change.

"bete" <bete@discussions.microsoft.com> wrote...

> iS THERE ANYWAY TO HAVE THIS AS A FORMULAE ?

Reply to this Message

David McRitchie - 24 Mar 2007 02:45 GMT

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/event.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
>
> > 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.

Reply to this Message

bete - 24 Mar 2007 04:18 GMT

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

> 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
[quoted text clipped - 20 lines]
> > > I do not want it to change after a minute, I want it to stay as it was
> > > first entered. Is this possible.

Reply to this Message

David McRitchie - 25 Mar 2007 00:22 GMT

You have the code it is VBA, and everybody has to start sometime
http://www.mvps.org/dmcritchie/excel/event.htm#timestamp
and the directions to install it arfe on the same page which is
rightclick on the worksheet tab, view code, paste code in...
so it shouldn't make any difference how simple or complicated
it is because you have the code and the means to use it.

If you are now trying to add drop down menus in column B
into the mix you would have to look at
http://www.contextures.com/tiptech.html
but you should concentrate on one problem at a time.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Thank you
> I have had a look at all three suggestions. unfortunately VBA is a little
[quoted text clipped - 29 lines]
> > > > I do not want it to change after a minute, I want it to stay as it was
> > > > first entered. Is this possible.

Reply to this Message