Thread: Express a large number in fewer digits $1,264,567.50 = $1.3 M
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default 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

Reply With QuoteReply With Quote