{"id":8872,"date":"2022-02-01T15:55:46","date_gmt":"2022-02-01T15:55:46","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=8872"},"modified":"2024-03-26T15:33:07","modified_gmt":"2024-03-26T15:33:07","slug":"format-numbers-in-thousands-and-millions","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/format-numbers-in-thousands-and-millions\/","title":{"rendered":"Format Numbers in Thousands and Millions in Excel"},"content":{"rendered":"\n
When you are dealing with large numbers where precision is less important than readability, there are a few methods you can use to display numbers in a way that they are easy to digest.<\/p>\n\n\n\n
The first quick way to change the format in which the number is displayed is to add the thousands separator<\/strong>.<\/p>\n\n\n\n You can find it in Home >> Number<\/strong> group.<\/p>\n\n\n\n This command will automatically add the decimal part to the end o the number if we used it on an integer or rounds up to two digits after the decimal point.<\/p>\n\n\n\n If you want to get rid of the decimal part, you can click the Decrease Decimal<\/strong> command that is located in the same group.<\/p>\n\n\n\n Now, the numbers are formated into groups of three numbers:<\/p>\n\n\n\n If you want to add a thousands separator to a single number, you can do it by adding a comma after the first character, but before the third one from the end. So the number should consist of at least 4 digits.<\/p>\n\n\n\n Place a comma between any of these numbers.<\/p>\n\n\n\n Press Enter<\/strong>. Now, the numbers are already separated. Notice that there is no decimal value added to the number.<\/p>\n\n\n\n Another way to quickly add the thousands separator is to use the Excel SEO plugin<\/a>.<\/p>\n\n\n\n After you add it, navigate to SEO >> Humanize<\/strong>.<\/p>\n\n\n\n Click to button to expand the menu. The last of them adds the thousands separator to a number.<\/p>\n\n\n\nUsing shortcut<\/h2>\n\n\n\n
Using a free plugin for separator<\/h2>\n\n\n\n