Skip to content
Excel

VALUE function in Excel

Converts a text argument to a number

=VALUE(text)

VALUE syntax and parameters

One argument, one required.

  • textstringRequired

    The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

VALUE examples

Formulas you'll actually reuse.

  1. A number stored as text (“1,250.00”) turned into a real number:

    =VALUE(A2)

    Result1250

  2. The numeric part of a code, as a number you can sort and sum:

    =VALUE(MID(A2, 5, 5))

    Result10422

VALUE in Google Sheets

Same name — your formula ports as-is.

Try VALUE in the playground

Edit the example — nothing to install.

Preloaded with the VALUE formula from Example 1 — change anything and watch it respond.

Loading the editor…

VALUE errors

What they mean — and the fixes.

  • #VALUE!

    The text isn't in a recognised number, date, or time format — non-breaking spaces and currency symbols from web exports are the usual culprits.

Related functions

More ways Excel gets this done.