Convert currency to $X.XMM

[Guest]

Is it possible to convert $5,682,000.00 to $5.6MM in Excel? I think the
$5.6MM abreviation is pretty widely used, but I'm not sure how to customize
to that.

 

[Guest]

Hmm, usually $5,682,000.00 would convert to $5.7MM. If that's acceptable,
then a custom format will work for you

Format>Cells>Number. Choose Custom in the right hand panel & then, under
Type use something along the lines of

$#,###.0,,"MM"_);($#,###.0,,"MM")

That will leave the underlying value alone, but will present it as
described. Be aware that anything less than 50,000 will be shown as $0.0MM

 

[RagDyer]

Try this custom format:

$#.##,,"MM"

Which will give you $5.68MM.

You would have to round your cell (formula), to get:
$5.6MM
With a format of:
$#,#"MM"

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[RagDyer]

Correction to second format.
Should be:
You would have to round your cell (formula), to get:
$5.6MM
With a format of:
$#.#,,"MM"