Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Is there a way to keep a running account of each time the date was updated in
a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Alice,
Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Alice" wrote in message ... | Is there a way to keep a running account of each time the date was updated in | a spreadsheet. I was using the NOW function to update the date each time a | spreadsheet was updated but it overwrites the last date entered. I need each | date to remain so that EACH time the spreadsheet is updated, a new date is | entered. Can you help? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
OK...now I have to show my ignorance about Excel. Where do I enter this
code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
That isn't code, just select your cell, and hit those keys.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
It's a keyboard shortcut, press ctrl + shift & ;
-- Regards, Peo Sjoblom "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Thank you for your help and thank you for your patience with me!
"Bob Phillips" wrote: That isn't code, just select your cell, and hit those keys. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Thank you! One question though: You show to use a semi colon and Bob shows
to use a colon - what is the difference? "Peo Sjoblom" wrote: It's a keyboard shortcut, press ctrl + shift & ; -- Regards, Peo Sjoblom "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
This worked great and thank you again. One more question..... I changed the
format to enter both date and time but when I do the CTRl :, it gives me both the date and time but the time is not current time but rather 12:00 AM. I've used the NOW function before to get current date and time and it worked but that's where I ran into problems because it wouldn't hold previous dates/times. Is there a way I can have both - dates are kept and not overwritten and current time is displayed? "Bob Phillips" wrote: That isn't code, just select your cell, and hit those keys. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
To get a colon you need to hit the shift key as well since the default
result of hitting just the semicolon/colon key is a semicolon. Sorry for the confusion -- Regards, Peo Sjoblom "Alice" wrote in message ... Thank you! One question though: You show to use a semi colon and Bob shows to use a colon - what is the difference? "Peo Sjoblom" wrote: It's a keyboard shortcut, press ctrl + shift & ; -- Regards, Peo Sjoblom "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Note that you can't get seconds with this, anyway to get both you need to do
the date keypress first (ctrl + ;) then press space and then do ctrl +: (this time I did it without the shift key) -- Regards, Peo Sjoblom "Alice" wrote in message ... This worked great and thank you again. One more question..... I changed the format to enter both date and time but when I do the CTRl :, it gives me both the date and time but the time is not current time but rather 12:00 AM. I've used the NOW function before to get current date and time and it worked but that's where I ran into problems because it wouldn't hold previous dates/times. Is there a way I can have both - dates are kept and not overwritten and current time is displayed? "Bob Phillips" wrote: That isn't code, just select your cell, and hit those keys. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date
Oh DUH!!!! Sorry I'm really not that dumb :( I didn't read your response
very well and didn't realize you had said 'shift + ;". Sorry to bother you. "Peo Sjoblom" wrote: To get a colon you need to hit the shift key as well since the default result of hitting just the semicolon/colon key is a semicolon. Sorry for the confusion -- Regards, Peo Sjoblom "Alice" wrote in message ... Thank you! One question though: You show to use a semi colon and Bob shows to use a colon - what is the difference? "Peo Sjoblom" wrote: It's a keyboard shortcut, press ctrl + shift & ; -- Regards, Peo Sjoblom "Alice" wrote in message ... OK...now I have to show my ignorance about Excel. Where do I enter this code? I'm truly not familiar with this program at all....just learning. Thank you! "Bob Phillips" wrote: Alice, Use Ctrl-: (colon) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Alice" wrote in message ... Is there a way to keep a running account of each time the date was updated in a spreadsheet. I was using the NOW function to update the date each time a spreadsheet was updated but it overwrites the last date entered. I need each date to remain so that EACH time the spreadsheet is updated, a new date is entered. Can you help? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input a date or update it based on date in another cell | New Users to Excel | |||
Date Update | Excel Worksheet Functions | |||
How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Automatic Date Update | Excel Discussion (Misc queries) | |||
Date update | Excel Discussion (Misc queries) |