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.

Format cells, numbers, text, and other data in Excel to improve readability. Learn how to apply borders, shading, text colors, and more.

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.

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.

Use Excel's Get & Transform (Power Query) experience to format individual columns as text when you import data. In this case, we're importing a text file, but the data transformation steps are …