ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Default Date Format (https://www.excelbanter.com/excel-discussion-misc-queries/113527-default-date-format.html)

Loris

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?

Stephen Bye

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?




Loris

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?






All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com