Excel Function

VALUE

Converts text that represents a number into number.

VALUE(text)

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use VALUE to Converts text that represents a number into number. use B2 for text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=VALUE(B2)

Practice This Function

Practice in Sequential Mode Back to Function List