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 to excel. Any information is appreciated, thanks!

  • 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. 

     

  • aricgresko's avatar
    aricgresko
    Contributor III

    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. 

     

    • EW97's avatar
      EW97
      New Contributor

      Looks like that worked, thanks!