custom format for accouting value detected as date

Using openpyxl version 3.0.10 the following custom numeric format for an accounting value is detected as a date format:

#,##0.00\ _M"H"_);[Red]#,##0.00\ _M"S"_)

For example a numeric value of 10000 should be displayed as 10.000,00 H and -10000 as 10.000,00 S .

Minimal testfile attached.Test.xlsx

Edited Apr 18, 2023 by Lennart Brinkmann

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information