View Single Post
  #1   Report Post  
morrowjr
 
Posts: n/a
Default Show Dollars in Millions

Is there a formula in Excel that changes a calculated dollar figure so that
it just shows in the 000,000's? For example, I have a calculated figure of
$15,806,375,100. However, in my chart, I just want to show $15,806. I there
a way for Excel to do this so that I don't have to type all my figures
manually? Thanks!