Forum Discussion

matthewsb419's avatar
matthewsb419
New Contributor
2 days ago

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 with parentheses, and I'm super close, but I have this odd space at the end I can't seem to solve.  ChatGPT got me here: 

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

But it's stuck there. 

No RepliesBe the first to reply