basjh.blogg.se

Select the cells for which you wish to display a currency symbol.To display numbers with a currency symbol in Microsoft Excel: On the Home tab, in the Number group, click the Comma Style command.Select the cells for which you wish to display numbers with a thousands separator.To display numbers with a thousands separator (a comma) in Microsoft Excel: Numbers in Excel can be formatted to show commas, show currency symbols, appear as percentages, and more. This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016. However, numbers can be formatted to appear in many different ways. How to Format Numbers in Microsoft Excel See Microsoft Excel: Tips and Tricks for similar articles.īy default, numbers in Microsoft Excel do not show commas and do show the first two decimals (unless they are 0).