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