For work I have to use an Excel version in German. Excel handles the month of March (März) in a strange/wrong way. The standard German abbreviation in the month's list is MRZ (if I fill a series of months I get JAN, FEB, MRZ, ...). Similarly, if I format a date, say 1st of March 2024, with "DD-MMM-YYYY"
(or, more correctly in German, "TT-MMM-JJJJ"
) I get "01-Mrz-2024"
.
However, this get produces an error:
= DATEVALUE("1-Mrz-24")
.. while this is correct:
= DATEVALUE("1-Mär-24")
There is apparently a lack of internal coherency: sometimes I have to use MRZ and sometimes MÄR. This creates problems when I link a DATEVALUE formula to a date cell.
Does anybody know how to fix it?
In Control Panel set the following:
Region and Language
-> Formats
-> Format
Set this to German (Austria)