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
related to #1413 (closed).
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information