To enter a specific date or time format, such as January 2010, you can format it as text by selecting Text in the Category list. To quickly enter the current date in your worksheet, select any empty cell, and then press CTRL+; (semicolon), and then press ENTER, if necessary.

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 format, or you want to combine numbers with text or symbols.

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.

In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type. You can adjust this format in the last step below. Go back to the Category list, and choose Custom. Under Type, you’ll see the format code for the date format you chose in the previous step. The built-in date format ...

To enter a specific date or time format, such as January 2010, you can format it as text by selecting Text in the Category list. To quickly enter the current date in your worksheet, select any empty cell, and then press CTRL+; (semicolon), and then press ENTER, if necessary.

The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.

To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them. Select the cell that contains the text-formatted date that you want to convert.

By applying different number formats, you can display numbers as percentages, dates, currency, and so on. For example, if you're working on your quarterly budget, you can use the Currency number format to show monetary values.

Use number formats to change the appearance of numbers, including dates and times, without changing the actual number. You can also change how negative numbers are displayed and control the display of digits after the decimal point in a number.

In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type. You can adjust this format in the last step below. Go back to the Category list, and choose Custom. Under Type, you’ll see the format code for the date format you chose in the previous step. The built-in date format ...