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