Enter and format data - Microsoft Support
Format numbers. Format numbers as percentages. Format a date the way you want. Format text in cells. Format numbers as dates or times. Format numbers as currency. Keeping leading zeros and large numbers. Create or delete a custom number format. Hide or show gridlines on a worksheet. Change the case of text. Convert numbers stored as text to ...
Review guidelines for customizing a number format
To create a custom number format, you start by selecting one of the built-in number formats as a starting point. You can then change any one of the code sections of that format to create your own custom number format. A number format can have up to …
Create a custom number format - Microsoft Support
Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes, see Review guidelines for customizing a number format.
Quick Start: Format numbers in a worksheet - Microsoft Support
In the Category list, click the format that you want to use, and then adjust settings, if necessary. For example, if you're using the Currency format, you can select a different currency symbol, show more or fewer decimal places, or change the way negative numbers are displayed.
Format numbers - Microsoft Support
Format numbers as dates, currency, or even fractions to cells in a worksheet. For example, if you’re working on your quarterly budget, the Currency number format shows your numbers as money.
Convert numbers stored as text to numbers in Excel
Check out Format numbers to learn more about formatting numbers and text in Excel.
Change the date system, format, or two-digit year interpretation
Because dates and times are values, they can be added, subtracted, and included in other calculations. You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.
Convert dates stored as text to dates - Microsoft Support
The date format will also be more useful if you want to filter, sort, or use it in date calculations. Select the cell, cell range, or column that you want to reformat. Click Number Format and pick the date format you want.
Available number formats in Excel - Microsoft Support
Applying a number format only changes how the number is displayed and doesn’t affect cell values that’s used to perform calculations. You can see the actual value in the formula bar. Here’s a list of available number formats and how you can use them in Excel for the web:
TEXT function - Microsoft Support
Following are some examples of how you can apply different number formats to your values by using the Format Cells dialog box, and then use the Custom option to copy those format codes to your TEXT function.
Format a date the way you want - Microsoft Support
The built-in date format can’t be changed, so don’t worry about messing it up. The changes you make will only apply to the custom format you’re creating. In the Type box, make the changes you want using code from the table below.