Automatically Convert values to $M

Good Morning,
I am wondering if there is a way to automatically convert my values to
$M I also want my scale to read $1M, $2M, $3M, etc.... Is there a way to do
this automatically?
--
Thank You,
Steve

Similar to your other post, custom number format
#,,"M"

Cheers
Andy

Steve D wrote:
> Good Morning,
> I am wondering if there is a way to automatically convert my values to
> $M I also want my scale to read $1M, $2M, $3M, etc.... Is there a way to do
> this automatically?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info