- OneStream Community
- Forums
- Reporting
- Cube View Excel Cell Formatting
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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!
Solved! Go to Solution.
- Labels:
-
Cube View
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Looks like that worked, thanks!
