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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel Table Headers Show in Columns Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality. For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you ...
Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error. This means that the formula refers to a cell that isn’t valid. To get rid of this error message we have to select the cell(s) with this error, ...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list. A dynamic drop down list expands as the Excel Table expands when new data gets added to it. This is great when you want to have users select from a predefined ...
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...