Excel Tip #25: An Abbreviated Custom Format for Millions, Billions and Trillions

Internally, Excel keeps track of all your digits. But, if you’re dealing with a large number, you’re limited to 3 display choices.

• Showing all the digits
• Using scientific notation
• Relabeling the column as, say thousands, and then reducing the number of digits shown.

For example, you might have GDP in a spreadsheet. You can show this as:

• $15,320,800,000,000
• $1.53208E+13
• 15.3208 (with a notation many readers won’t notice that this is in trillions)

Susan Harkins at TechRepublic suggests creating a custom format that matches what you’d write by hand.

Specifically,

• Select your cell
• Open a “Format Cells” dialog window (click ALT then H then F then M)
• Click the “Number” tab (or click N)
• Choose “Custom” (sorry, gotta’ click that one)
• Choose the “Type” box (ALT+T)
• Enter one of the the following (for millions, billions, or trillions)
  • $#,,” M”
  • $#,,,” B”
  • $#,,,,” T”

There’s one more exceptionally cool thing about this format: it rounds automatically.

Technorati Tags: excel,tip,25,custom,format,millions,billions,trillions

Comments

[hekvvddtest]

http://03.hbtx8.cn/read.php?tid=403569&ds=1
http://114.32.66.110/mobile01/viewthread.php?tid=4433999&extra=
http://progressiveastronomy.org/node/4#comment-5506614
http://www.bridge-tunnle.com/bbs/showtopic-3981637.aspx
http://www.profesionalesdigitales.es/profesionales/?
http://203.198.127.224/forum/forum.php?mod=viewthread&tid=6762316
http://www.gisblog.org/map/mashup/2006/01/24/technology/outreach.geo#comments
http://narajin.net/recomen/2005/03/delay1968.html#comments


Many people believe that just high heel shoes may showcase the actual charm of the high as well as assured lady. http://kobebryantshoes.zohosites.com>kobes shoes

http://www.comulberryoutlet.co.uk>mulberry outlet Actually, high heel shoes can't complement using the Stuart Weitzman Jennifer Aniston Espadrilles Wedge Shoes comfort and ease element.