How do I use VALUE in Excel?
Use VALUE when you want to convert number-like text into real numbers. Enter Text in that order, then add optional arguments when needed.
Excel Function
VALUE
Converts text that represents a number into number.
VALUE(text)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
Practice Preview
Use VALUE to convert the numeric text in cell E2 (Amount Text in column E) to a number.
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | E003 | Ken Sato | k.sato@example.com | 2450 | 2450 |
| 5 | E004 | Aya Takahashi | a.takahashi@example.com | 3000 | 3000 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=VALUE(E2)Result
1200
Practice This Function
VALUE FAQ
Where can I practice VALUE?
Use the "Start Function Practice" button to jump straight into VALUE drills.
What arguments does VALUE use?
The main arguments are Text. Enter them in order.