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

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, …

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 …

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.

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.

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.

The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable …

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 …

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 …

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.