Tip of the Week #61                     Tip Index

Go to the Prior Tip PowerPoint: an Inferior Solution ... for me
Go to the Next Tip Faster: The Acceleration of Just About Everything
Return to MaxValue Home Page

Formatting Thousands and Millions in Excel

Ever develop an evaluation in dollars and wish that you had used thousands or millions, instead?

There is an easy way to display thousands or millions without having to divide.  Use the 'Custom' cell format and enter ‘0,’ for thousands, or ‘0,,’ for millions [without the quotes].

If you want some decimals also, use a format as suggested by these examples:

Value Format
Template

Displays

22,222,222.222 #,###.000, 22,222.222
22,222,222.222 #,###.0,, 22.2
22,222,222.222 #,###.0,, -22.2

—John Schuyler, October 1999

Copyright 1999 by John R. Schuyler. All rights reserved. Permission to copy with reproduction of this notice.