<div class="raw-html-embed">    <p>The <b>NUMBERVALUE</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to convert text to a number, in a locale-independent way. If the converted text is not a number, the function will return a <b>#VALUE!</b> error.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>NUMBERVALUE(text, [decimal_separator], [group_separator])</em></b></p>
    <p>The <b>NUMBERVALUE</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>text</em></b></td>
                <td>The text data that represents a number.</td>
            </tr>
            <tr>
                <td><b><em>decimal_separator</em></b></td>
                <td>The character used to separate the integer and fractional part of the result. It is an optional argument. If it is omitted, the current locale is used.</td>
            </tr>
            <tr>
                <td><b><em>group_separator</em></b></td>
                <td>The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. It is an optional argument. If it is omitted, the current locale is used.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>NUMBERVALUE</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>NUMBERVALUE</b> function.</p>
    <p><img alt="NUMBERVALUE Function" src="https://static-helpcenter.teamlab.info/numbervalue_d025b7686d.png"></p></div>

NUMBERVALUE Function

Docs

Argument	Description
*text*	The text data that represents a number.
*decimal_separator*	The character used to separate the integer and fractional part of the result. It is an optional argument. If it is omitted, the current locale is used.
*group_separator*	The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. It is an optional argument. If it is omitted, the current locale is used.

NUMBERVALUE Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud