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