By default, numbers in Microsoft Excel do not show commas and do show the first two decimals (unless they are 0). However, numbers can be formatted to appear in many different ways.
This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.
Numbers in Excel can be formatted to show commas, show currency symbols, appear as percentages, and more.
To display numbers with a thousands separator (a comma) in Microsoft Excel:
To display numbers with a currency symbol in Microsoft Excel:
To display numbers as percentages in Microsoft Excel:
Microsoft Excel actually stores dates as numbers, so displaying dates is really a formatting issue. Excel allows you to display dates in many ways. For example, January 15, 2016 can be displayed as:
To set or change the way dates are displayed in Microsoft Excel:
To change the number of decimals showing for numbers in Microsoft Excel:
Dave Dunn joined Webucator as Chief Operating Officer in early 2009. He has served as a CFO and COO for numerous small and medium-sized companies, including Summit Software Company, Insight Research Group, Avalon Consulting, CampaignBase.com and HealthcareOne. He has expertise in business development, financial management, marketing and human resources and particularly enjoys working with rapidly growing companies.
Dave received his Bachelor of Arts from Hamilton College and his MBA from Syracuse University. He has served as Chairman of the Board of the Montessori School of Syracuse since 2001.