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.

If numbers have too many decimal places, on the Home tab, select Decrease Decimal. If dates are too long, on the Home tab, select the Number Format arrow, and pick Short Date.

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.

Apply number formats such as dates, currency, or fractions to cells in a worksheet. For example, if you're working on your quarterly budget, you can use the Currency number format so your …

To fix this, change the number of times Excel iterates formulas: Select File > Options. On the Formulas tab, under Calculation options, check the Enable iterative calculation box. In the …

For the most part, numbers that are formatted with the General format are displayed just the way that you type them. However, if the cell is not wide enough to show the entire number, the …

Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or …

The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and …

Excel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15, in order to allow formulas and math operations to work on them.