|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
|