Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
At the risk of sounding like an idiot (I'm already feeling like one, so what
the heck), when I select a cell and type 'control+' either simultaneously or seperately, I still don't get a date stamp. Simultaneously typed, I get an Insert window, seperately typed, I get a '+' character in the cell. It doesn't seem to matter if I use the number pad or the main keyboard. So, what the heck am I doing? FYI, I have Excel 2003, SP1. Thanks for the help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Don't type the plus sign. Hold the CTRL key, press the ' key and then
release both -- Kind regards, Niek Otten "babs" wrote in message ... At the risk of sounding like an idiot (I'm already feeling like one, so what the heck), when I select a cell and type 'control+' either simultaneously or seperately, I still don't get a date stamp. Simultaneously typed, I get an Insert window, seperately typed, I get a '+' character in the cell. It doesn't seem to matter if I use the number pad or the main keyboard. So, what the heck am I doing? FYI, I have Excel 2003, SP1. Thanks for the help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
You are not an idiot. Try CNTRL;
-- Gary''s Student "babs" wrote: At the risk of sounding like an idiot (I'm already feeling like one, so what the heck), when I select a cell and type 'control+' either simultaneously or seperately, I still don't get a date stamp. Simultaneously typed, I get an Insert window, seperately typed, I get a '+' character in the cell. It doesn't seem to matter if I use the number pad or the main keyboard. So, what the heck am I doing? FYI, I have Excel 2003, SP1. Thanks for the help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Oh, I was so right about me being an idiot. After trying both of your
suggestions, I went back and reread the Microsoft help stuff. The little light bulb clicked on finally. I totally misread their use of the plus sign! What can I say?! Thanks folks for helping me! -Babs "Gary''s Student" wrote: You are not an idiot. Try CNTRL; -- Gary''s Student "babs" wrote: At the risk of sounding like an idiot (I'm already feeling like one, so what the heck), when I select a cell and type 'control+' either simultaneously or seperately, I still don't get a date stamp. Simultaneously typed, I get an Insert window, seperately typed, I get a '+' character in the cell. It doesn't seem to matter if I use the number pad or the main keyboard. So, what the heck am I doing? FYI, I have Excel 2003, SP1. Thanks for the help! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Yes, wrong. My focus was on the interpretation of the + sign.
-- Kind regards, Niek Otten "Sandy Mann" wrote in message ... Now I feel like an idiot, isn't it Ctrl + ; that inserts today's date? Ctrl + ' just enters me into edit mode. -- Sandy with @tiscali.co.uk "babs" wrote in message ... Oh, I was so right about me being an idiot. After trying both of your suggestions, I went back and reread the Microsoft help stuff. The little light bulb clicked on finally. I totally misread their use of the plus sign! What can I say?! Thanks folks for helping me! -Babs "Gary''s Student" wrote: You are not an idiot. Try CNTRL; -- Gary''s Student "babs" wrote: At the risk of sounding like an idiot (I'm already feeling like one, so what the heck), when I select a cell and type 'control+' either simultaneously or seperately, I still don't get a date stamp. Simultaneously typed, I get an Insert window, seperately typed, I get a '+' character in the cell. It doesn't seem to matter if I use the number pad or the main keyboard. So, what the heck am I doing? FYI, I have Excel 2003, SP1. Thanks for the help! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Now let a true idiot speak. When I press control & + keys. All I get is the "insert" control box. When I press control & ; I get the date, but no time. When I press control & ' I get nothing. I haven't gotten the "time" yet, even when formatting the cell for time and date. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=520173 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Press CTRL & :
-- Kind regards, Niek Otten "lsmft" wrote in message ... Now let a true idiot speak. When I press control & + keys. All I get is the "insert" control box. When I press control & ; I get the date, but no time. When I press control & ' I get nothing. I haven't gotten the "time" yet, even when formatting the cell for time and date. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=520173 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time/Date Stamp: 'control+' not working for me...
Ctrl + ; inserts the date as you said, Ctrl + SHIFT + ; (or in other words
Ctrl + : ) inserts the time so: Ctrl + ; then <space then Ctrl + : inserts the date and time -- HTH Sandy with @tiscali.co.uk "lsmft" wrote in message ... Now let a true idiot speak. When I press control & + keys. All I get is the "insert" control box. When I press control & ; I get the date, but no time. When I press control & ' I get nothing. I haven't gotten the "time" yet, even when formatting the cell for time and date. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=520173 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My control toolbox functions are not working correctly. | Excel Discussion (Misc queries) | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |