Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date Format
In Excel 2003, when I try formatting a number as a date using the CTRL-SHFT-#
shortcut, it displays as dd-mmm-yy, e.g., 10-Oct-06. I thought it might be controled by the short date format in Regional settiongs in Control Panel, but that shows as mm/dd/yyyy. Does anyone have any idea what is controling the format used by CTRL-SHFT-# and where I can go to change it? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Date Format
I'm not sure you can change it.
But you can intercept that keystroke and do what you want. You could add a couple of routines to your personal.xls (or any workbook that opens when excel starts): Option Explicit Sub myDateFormat() Selection.NumberFormat = "mm/dd/yyyy" End Sub Sub auto_close() Application.OnKey "^#" End Sub Sub auto_open() Application.OnKey "^#", "myDateFormat" End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Loris wrote: In Excel 2003, when I try formatting a number as a date using the CTRL-SHFT-# shortcut, it displays as dd-mmm-yy, e.g., 10-Oct-06. I thought it might be controled by the short date format in Regional settiongs in Control Panel, but that shows as mm/dd/yyyy. Does anyone have any idea what is controling the format used by CTRL-SHFT-# and where I can go to change it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell date format doesnt change | Excel Worksheet Functions | |||
Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) |