In this session we can learn this video, I will show you a really easy way to show numbers in millions or billions in Excel (Malayalam). Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the ability to add thousands separators without changing the cell values. In this article, we're going to show you how to format numbers in Excel with million separators.
Steps:
Select the cells you want format.
Press Ctrl+1 or right click and choose Format Cells… to open the Format Cells dialog.
Go to the Number tab (it is the default tab if you haven't opened before).
Select Custom in the Category list.
Example : Type in #,##0.0,, "M" to display 1,500,800 as 1.5 M
Click OK to apply formatting.
#excelmalayalam #exceltricks #skillstosucceedbyalfan
31 янв 2022
