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.

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

FormatCellsNumber. 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


"StephanieH" wrote:

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.

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!
==============================================


"StephanieH" wrote in message
...
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.

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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
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!
==============================================


"StephanieH" wrote in message
...
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.