exceldatecelldate-formatcell-formatting

Problems with Excel handling of the month of March in German language


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?


Solution

  • In Control Panel set the following:

    Region and Language -> Formats -> Format

    Set this to German (Austria)