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 …

Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats …

Format cells by including predefined formatting styles, and things like borders and fill colors.

The text dates with two-digit years convert to standard dates with four-digit years. Once you have converted the cells from text-formatted dates, you can change the way the dates appear in 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.

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to …

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.

On the Home tab, in the Number group, select the arrow next to the Number Format box, and then select Text. If you don't see the Text option, scroll to the end of the list.

Select the text you want to reformat, right-click it, and then go to the Home tab, and change your font settings in the Font group.

Adjust the row height to make all wrapped text visible Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, select Format. Under Cell Size, …