Skip to main content
E
EW97
April 10, 2024
Solved

Cube View Excel Cell Formatting

  • April 10, 2024
  • 1 reply
  • 0 views

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!

Best answer by aricgresko

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. 

 

1 reply

A
aricgreskoAnswer
April 10, 2024

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. 

 

E
EW97Author
April 15, 2024

Looks like that worked, thanks!

Terms & ConditionsAccessibility statement