Forum Discussion

matthewsb419's avatar
matthewsb419
New Contributor II
8 days ago
Solved

Cheat sheet for Formatting Syntax

Hi, Can someone point me to a syntax cheat sheet for formatting cube views and reports in Excel? I'm trying to get this number to show in thousands and have my negative numbers be in red...
Cube View
Reports
MarcusH's avatar
MarcusH
Valued Contributor
5 days ago

Try this:

ExcelNumberFormat = [#,##0,;[Red](#,##0,)]

matthewsb419's avatar
matthewsb419
New Contributor II
5 days ago

Hi Marcus,

Thanks for this suggestion, is there somewhere I can learn this? I'd love to be able to understand how this syntax solved my problems versus the earlier two versions I tried.  I'm trying to learn :)