Express a large number in fewer digits $1,264,567.50 = $1.3 M

[Mumpa]

Do you know how to automatically change a large number in fewer digits?

Express a large number in fewer digits $1,264,567.50 = $1.3 M
Like as $1.265 or $1.3 M

 

[Jim Cone]

Use a custom number format for the cells you want to display in a shortened format.
A comma whacks off three places, so try this for starters...
$0.0,," M"_)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Mumpa" <[email protected]>
wrote in message
Do you know how to automatically change a large number in fewer digits?
Express a large number in fewer digits $1,264,567.50 = $1.3 M
Like as $1.265 or $1.3 M

 

[Mumpa]

Thanks Jim