Want to format Number to show 600,000,000 as 600

[Legacy 107345]

Trying to format a number in Excel 2007 to show 600 million as 600 instead of 600,000,000. I tried trunc function, round function but kept getting the same results. I also tried to use the formatting section but could not find an answer. Any suggestions?

Thank you.

 

[xld]

Format the cell as 0,,

 

[lenze]

Use a "Custom Format". Format>Cells>Custom. For Type, enter something like

[>=1000000]#,," M";[>=1000]#," K";#

You can play aroune eith the options
lenze

 

[Legacy 107345]

Thank you, Thank you, A thousand times Thank you!

 

[SteveO59L]

Use custom number format


#.000,,