Forum Discussion
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...
I just played around with the format in Excel itself so any online resource for custom formatting of numbers will help. Have a look at this:
https://cheatography.com/nqramjets/cheat-sheets/excel-cell-number-formatting/pdf/
Try this:
ExcelNumberFormat = [#,##0,;[Red](#,##0,)]
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 :)
I just played around with the format in Excel itself so any online resource for custom formatting of numbers will help. Have a look at this:
https://cheatography.com/nqramjets/cheat-sheets/excel-cell-number-formatting/pdf/
Got it, I didn't realize that it was all just the same as excel, but that makes total sense. Thanks!
