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
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