Is there a formula to show $5,000,000 as $5M?

I am looking for an easy way to convert $M values to eliminate the 6 zeros.

Thanks.

You could try something like this:
=IF(RIGHT(A1,6)="000000",A1/1000000&"M",A1)

unless someone has a better idea....

Sheila

"ExcelHelp" wrote:

> I am looking for an easy way to convert $M values to eliminate the 6 zeros.
>
> Thanks.

Another option:
=TEXT(A1,"$ #,, ""M""")

Another option would be to keep the value in the cell, and use a similar
Custom format.

--
Dana DeLouis
Win XP & Office 2003


"ExcelHelp" <[email protected]> wrote in message
news:[email protected]...
>I am looking for an easy way to convert $M values to eliminate the 6 zeros.
>
> Thanks.

On Thu, 3 Mar 2005 13:39:27 -0500, "Dana DeLouis"
<[email protected]> wrote:

>Another option:
> =TEXT(A1,"$ #,, ""M""")
>
>Another option would be to keep the value in the cell, and use a similar
>Custom format.
Custom format
$ 0,,\M