Forum Discussion
Solved
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...
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.
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.
Looks like that worked, thanks!
