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

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



Doh! Didn't see the "chart" bit......