Large numbers in Excel can be formatted so they can be shown in “Thousands” or “Millions”.

By using the Format Cells dialogue box shortcuts CTRL+1, you will need to select CUSTOM and then enter one comma to show Thousands or two commas to show Millions.

You can even add some text in your cells by entering any word within the quotation marks ” your word “.

Here is an example:

#,##0, “ths”

#,##0,, “mills”

DOWNLOAD WORKBOOK

Number Formats - Ths & Mills

HELPFUL RESOURCE:

eu_logo_150

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell.This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols!There are four formattin...
Excel Table: Styles There are lots of different Table Styles that you can choose from to spice up your Excel Table.  You can also customize your own style if you don't like any of the default Excel styles.To access the Table Styles, you simply need to click inside your Table and then the Table T...
Replace Excel Formatting with Another Formatting Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells.Then you decide that the bold text does not suit your expected design and prefer red colored text instead.What would you do?Changing all of the forma...
How to Insert an Excel Table Excel Tables are very powerful and have many advantages when using them.  You should start using them asap regardless of the size of your data set, as their benefits are HUUUGE:1. Structured referencing; 2. Many different built in Table Styles with color formatting; 3. Use ...