Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
iS THERE ANYWAY TO HAVE THIS AS A FORMULAE ?
"Paul B" wrote: bete, Ctrl+; for date and Ctrl+shift+; for time -- 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 "bete" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
No, because you did not want the timestamp to change.
"bete" wrote... iS THERE ANYWAY TO HAVE THIS AS A FORMULAE ? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
bete, Ctrl+; for date and Ctrl+shift+; for time
-- 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 "bete" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i enter date and time in cell without it changing
You have the code it is VBA, and everybody has to start sometime
http://www.mvps.org/dmcritchie/excel....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 "bete" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
Enter date and time in cell | Excel Discussion (Misc queries) | |||
how to enter date without using "/" each time? | Excel Discussion (Misc queries) | |||
how to enter date without using "/" each time? | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel |