Skip to main content
Newcomer
Apr 10, 2024 7:13 PM UTC
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 to excel. Any information is appreciated, thanks!

aricgresko
Veteran
Apr 10, 2024 8:15 PM UTC

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. 

 

2 replies

aricgresko
Veteran
Apr 10, 2024 8:15 PM UTC

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. 

 

EW97Author
Newcomer
Apr 15, 2024 2:10 PM UTC

Looks like that worked, thanks!