Excel help

[Propertunity]

having a brain overheat, in Excel:

How do you make $1,000,000 appear as $1.0M ?
...and $1,100,000 as $1.10M
please.

 

[Rooster]

Prop,

Does it matter if it rounds say $1,258,000 to -

$1.26M


Rooster

 

[Propertunity]

I think I could live with that. What's $5K between friends?

 

[Rooster]

I think I could live with that. What's $5K between friends?

Try:

[>100000]$#.00,,"M"

Custom format.

Cheers

Rooster

 

[Propertunity]

Thanks very much. That should do it.