 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2007Excel 2007 Date Keyboard Shortcut problem
The ctrl+; shortcut inserts the date as formatted in regional settings rather than the "day number" date. I want the "day number" date so I can process it. Any suggestions? TIA Daniel L. Lieberman I'm not sure why you can't process it as a date, but just change the format to general (or Number) after you apply the keystrokes. > The ctrl+; shortcut inserts the date as formatted in regional settings > rather than the "day number" date. I want the "day number" date so I can [quoted text clipped - 4 lines] > > Daniel L. Lieberman  SignatureDave Peterson Dave, That is the whole point the ctrl+; does not appear as anything other than a formatted date regardless of the cell formatting. To be more specific it does not enter the date serial number even if the cell is formatted as general. Daniel > I'm not sure why you can't process it as a date, but just change the > format to [quoted text clipped - 8 lines] >> >> Daniel L. Lieberman Dave, I get the same result a) starting Vista Business in safe mode, and b) starting excel in the safe mode (/s switch.) Daniel > Dave, > That is the whole point the ctrl+; does not appear as anything other than [quoted text clipped - 15 lines] >>> >>> Daniel L. Lieberman I meant format the cell as General after you hit the shortcutkey. Not before. Does that work? By the way, ctrl-shift-backquote (ctrl-tilde) is the shortcut key to change the format to General. > Dave, > That is the whole point the ctrl+; does not appear as anything other than a [quoted text clipped - 19 lines] > > > > Dave Peterson SignatureDave Peterson Dave, It doesn't matter you format the cell before or after using the shortcut key. What do you get when you use the key. I just tried using the key into general, long date and short date cells and then changing them and it made no difference. Daniel >I meant format the cell as General after you hit the shortcutkey. Not >before. [quoted text clipped - 30 lines] >> > >> > Dave Peterson You don't have a macro that steals the ctrl-; keystroke and does some special stuff, do you? I'd try opening excel in safe mode: Close excel windows start button|Run excel /safe and test it out > Dave, > [quoted text clipped - 44 lines] > > > > Dave Peterson SignatureDave Peterson Dave, I had not only checked it out with excel.exe /s but also running Vista is safe mode. I have also reinstalled. The ctrl+; is not in any Excel or Word macro. This is a real puzzle. It even enters the date into a cell formatted as "Number." Daniel > You don't have a macro that steals the ctrl-; keystroke and does some > special [quoted text clipped - 61 lines] >> > >> > Dave Peterson I don't have another guess. And you have the same problem if you create a new workbook and try it there??? (No matter your response, it won't help me. Sorry.) > Dave, > [quoted text clipped - 75 lines] > > > > Dave Peterson SignatureDave Peterson >>even if the cell is formatted as general. If the cell is 'number' formatted it stays a number. SignatureJim | Dave, | That is the whole point the ctrl+; does not appear as anything other than a | formatted date regardless of the cell formatting. To be more specific it | does not enter the date serial number even if the cell is formatted as | general. | Daniel |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.