Monday, November 4, 2013

Formatting a metric to Thousands

Eg of the Metric value:123412
Desired value (in '000) :1234
Eg of the metric value:-123412
Desired value (in '000):(1234)

In the metric formatting select Custom formatting and enter : #,##0,;(#,##0,);0


No comments:

Post a Comment