convert millions or billion

[Anonymous]

123451212121 to 12.3 mn

6123121212 to 6.0 mn

100000 to 0.1mn

[swuehl]

Maybe by just dividing your numbers by 1 Million or 1 Billion and adding an appropriate abbreviation?

=num(6123121212  / pow(10,9),'#.0') &' bn'

or

=num(6123121212  / pow(10,6),'#.0') &' mn'

More general for million conversion

=num(Value  / pow(10,6),'#.0') &' mn'

and conversion to billion

=num(Value  / pow(10,9),'#.0') &' bn'

In chart properties, number tab, you could also set million / billion symbols to convert your axis display.

Hope this helps,

Stefan