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.