Summary
This article details the usage of the Accounting cell format within Solver Cloud and Private Host.
Article sections:
More Information
“Accounting” cell format has been noted to not be supported within the web portal of 5x both Private Host and Cloud.
Using this format does not lead to the same results in the portal as in Excel. For example, a cell with “Accounting” format with the amount 123123123.123 displays as 123,123,123.12 in Excel, but looks like the cell’s value of 123123123.123 in the portal.
Ultimately, the “Number” format was used with comma separator and two decimals to replicate the “Accounting” look/feel. The “comma” format mask, which shows as Accounting in Excel, has never worked in the cloud and a Number format must be configured instead.
The one thing fixed with Accounting was that trailing zeros are not dropped when dropped.
You can also use the following as a custom formatting to work around it:
| " - " for 0 | #,##0_);(#,##0);_(* "-"??_);_(@_) |
| " - " for 0 & x.00 | #,##0.00_);(#,##0.00);_(* "-"??_);_(@_) |
| $ x,xxx for currency | $* #,##0_);$* (#,##0);_($* "-"??_);_(@_) |
Properties
Applies To:
- Solver Cloud
- Private Host