View Single Post
  #3   Report Post  
Gordon
 
Posts: n/a
Default

"morrowjr" wrote in message
...
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!


Set up a custom format of "###," (without the quotes, and the comma is
important!) That will show your example as 15806. Can't help with the
separator though! (This will round any figure up or down).

HTH