1
Windows 8.1, office 2013, english interface - danish region.
When working in excel I often paste dates from another application. These dates are in the form Januar 2013
. When pasting, it seems excel automatically recognizes this as a date, and converts the value to 01-01-2013
and a displayed value of Jan-2013
But for some months, e.g. may (which in danish is spelled 'Maj'), excel does not recognize the text. In this case Maj 2012
is displayed as such - and not converted to a date value.
I am aware of this ansvar - but in my case I need to copy the values with first saving as csv and then importing. Also changing to a custom format after pasting doesn't work either.
Is there anyway I can change the regional settings per sheets?
EDIT: Libre office can do what I need :-) See below.
This is my office excel settings
It works in libre office (the text is recognized as dates):
This is my Libre Office calc settings