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

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

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

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"
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

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

Thanks Jim

"Jim Cone" wrote:


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"
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