custom format for accouting value detected as date (#2014) · Issues · openpyxl / openpyxl

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](/uploads/2b093d99489c8a66e099992659cbf8b0/Test.xlsx) related to #1413.

issue