Name
VALUE
Synopsis
Use VALUE to convert a text string that resembles a number to a number. Since Excel functions automatically convert text to numbers as needed, this function is only needed for compatibility with other spreadsheet programs.
To Calculate
=VALUE(Text)Example
Figure 18-7 illustrates how you can use VALUE to convert a numeric text string to a number.
Get Excel 2000 in a Nutshell 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.
