Replacing a formula with its result can be helpful if there are many or complex formulas in the workbook and you want to improve performance by creating static data. You can convert …

If you want to replace only part of a formula, you can replace only the part that you don't want to recalculate. You can convert formulas to their values on a cell-by-cell basis or convert a whole …

In one of the cells of the new column, type =VALUE () and inside the parentheses, type a cell reference that contains text stored as numbers. In this example it's cell E23.

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

The TIMEVALUE function returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times …

This is because the DOLLAR function returns the number provided as text. Numbers stored as text are a common cause of spreadsheet errors, because many functions ignore them, such …

Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

You can reference the top cell with the values and use =TEXT (value,"00000"), where the number of zeros in the formula represents the total number of characters you want, then copy and …

Jan 1, 2008 · 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 …

#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 …