VALUE()

Syntax. VALUE(text)

Definition. The VALUE() function converts the text into a number.

Arguments

  • text (required). The text enclosed in quotation marks or the reference to the cell that contains the text you want to convert

Background. Excel converts numbers displayed as text values into numeric values. However, with data imported from third-party applications or with third-party add-ins, errors might occur.

Usually you do not need the VALUE() function within a formula, but you can convert a value list imported as text so that Excel can recognize and display the values:

  1. Enter 1 in an empty cell.

  2. Press Ctrl+C to copy the cell content into the Clipboard.

  3. Select the range containing the “text” numbers, click the Paste arrow on the Home tab, and click ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial