{"id":3310,"date":"2018-11-10T10:03:44","date_gmt":"2018-11-10T10:03:44","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3310"},"modified":"2024-03-26T15:33:07","modified_gmt":"2024-03-26T15:33:07","slug":"format-numbers-to-thousands-and-millions","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/format-numbers-to-thousands-and-millions\/","title":{"rendered":"Format Numbers to Thousands and Millions in Excel"},"content":{"rendered":"\n
If you have a very big number or a very narrow cell, you probably want to format your number in a way that will fit inside this cell, especially when the precision is not that important.<\/p>\n\n\n\n
In order to demonstrate that, we are going to use the following example.<\/p>\n\n\n\n You can copy this example.<\/p>\n\n\n\n The numbers in cells B1<\/strong> and C1<\/strong> are quite small, therefore we don\u2019t need to format them in any way. But D1<\/strong> and definitely E1<\/strong> are too big and it\u2019s hard to tell at the first glance whether they are millions or billions.<\/p>\n\n\n\n One to do it is by using the 1000 operator. It will separate thousands<\/a> with commas.<\/p>\n\n\n\nNumber<\/td> 213<\/td> 1765<\/td> 342000121<\/td> 4355554321<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n