The VALUE function converts a number or date entered as a string to a numeric value or a serial date/time value.
It is the reverse of the TEXT function, which converts a number to a string.
It is used to convert string state data imported from other applications or data obtained by string manipulation functions for inclusion in formulas such as four arithmetic operations.
How it works
|text||Required field||Specify the string to be converted to a numeric value (serial value).|
If a string that cannot be converted is specified, a #VALUE error occurs. Full-width, half-width, and currencies are widely supported.
If the argument is a range of cells, it will be a Spill.
You enter a formula in only one cell, but the
It is automatically expanded to the other cells.