Format numbers in Excel. This topic lists the formats and provides brief descriptions.

How? Select the cells that you want to format. On the Home tab, in the Number group, click the dialog box launcher next to Number (or just press CTRL+1). In the Category list, click the …

When you type numbers in your worksheet, Excel for the web automatically applies the General number format but you can change this to show specific number formats like dates, currency, …

On the Home tab, select the Number Format down arrow, then select More Number Formats at the bottom of the list. In the Format Cells dialog box, under Category, select Custom.

By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. If you need to display numbers with different separators for thousands or …

Sometimes, when numbers are imported or copied from an external source, they might come through formatted as text. You'll probably want to change the format to numbers otherwise it …

When numbers are actually stored in cells as text, problems with calculations or sorting can occur. Read this article to learn how to fix this problem.

Once you have converted the numbers formatted as text into regular numbers, you can change the way the numbers appear in the cells by applying or customizing a number format.

This article provides steps to change just your own regional format settings in Excel for the web. During your Excel for the web sessions, the SharePoint site regional settings will be overridden.

Excel provides a special number format that lets you format a number as a phone number. For example, you can format a 10-digit number, such as 5555551234, as (555) 555-1234. To see …