Deafult Date Format

bradders66

New Member
Joined
Jun 23, 2008
Messages
5
I've seen loads of posts about this but none that answered this problem.

We import data from an XML file, and the input date is (for example) 12MAR2013. Excel has no problem with this and correctly imports it fine, however the date display is "12-Mar-13". Now I know we can change how its shown by formatting it to a custom date pattern etc. but does anyone know if there is something somehwhere (thats is editable) that says dd-mmm-yy is the default format to use for all new spreadsheets. And before you say Regaional settings in Control Panel - nope, its not there either. We have English United Kingdoem set on everything and no hint or sign of dd-mmm-yy as a default
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Not the "Short date" format in Regional Settings?
 

bradders66

New Member
Joined
Jun 23, 2008
Messages
5
Not the "Short date" format in Regional Settings?

That "sort" of works but you can only change it to a limited amount of variations, with a limited amount of delimiters, so ddMMMyyyy isn't an option on there. In XP for example, the closest I could get it to was (form example) 26 Apr 2013, though I'd like to lose the gaps and have the month in caps, though this still displayed in Excel 2007 as "26 Apr 13", so still losing the full year bit!!. It says that by entering space as a delimiter it won't use one...but it lied!!
 

Forum statistics

Threads
1,136,775
Messages
5,677,655
Members
419,708
Latest member
PhilD

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top