Forum Discussion

EW97's avatar
EW97
New Contributor
9 months ago

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...
  • aricgresko's avatar
    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.