EW97
9 months agoNew Contributor
Cube View Excel Cell Formatting
Is there a way to format excel cell's = 0.000 when exported?
It is possible with Cube View formatting if NumberFormat = N4, but I cannot figure out a way to format it the same when exporting the CV...
- 9 months ago
Try using ExcelNumberFormat = [#,##0.0000].
If you go into Cell Format --> ExcelNumberFormat --> ...
You'll find some default number formats. Just select #,##0.00, then add additional zeros to that as needed.