Hyphen formatted numbers issue when exporting to excel.

This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed.

 

Issue

When setting a numbered line item to hyphen format. When exporting as xls or xlsx, the hyphen formatted cell will only ever display a hyphen, even when edited to be non zero cell values.


Workaround

The only means to workaround this is to remove the custom formatting on the cell in excel until this has been fixed.

 

---

Internal Reference: CORESRV-11117

Answers