| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default Date Format
Currently when I use the (CTRL-SHFT-#) keyboard shortcut on a number in Excel
2003, it formats it as dd-mmm-yy. Is there a way to change that format? If so, where do I need to go to do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default Date Format
Start Control Panel Regional and Language Options Regional Options
Customize Date Short date format "Loris" wrote in message ... Currently when I use the (CTRL-SHFT-#) keyboard shortcut on a number in Excel 2003, it formats it as dd-mmm-yy. Is there a way to change that format? If so, where do I need to go to do it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default Date Format
The Regional & Language Dialog box in control Panel has the short date as
(mm/dd/yyyy), 10/9/2006 So it would seem that something else is controlling the Excel (CTROL-SHFT-#) which is still showing it as 9-Oct-06 "Stephen Bye" wrote: Start Control Panel Regional and Language Options Regional Options Customize Date Short date format "Loris" wrote in message ... Currently when I use the (CTRL-SHFT-#) keyboard shortcut on a number in Excel 2003, it formats it as dd-mmm-yy. Is there a way to change that format? If so, where do I need to go to do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in numeric format | New Users to Excel | |||
| convert date format | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
Linear Mode
