Cube View Excel Cell Formatting

[EW97]

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 · Accepted solution]

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]

Looks like that worked, thanks!