Value

Syntax

Value(Text)

Parameters

Text. Text view of the number to be converted.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the result of converting a text view of a number into numeric view.

Example

Formula Result Description
=Value("12.5") 12,5 The string equivalent is 12.5.
=Value(B6) -124,3 Numeric equivalent of a string contained in the B6 cell. The B6 cell contains the value -124.3.

See also:

Function Wizard │ Text Functions │ Fixed