VALUE practice

VALUE converts a number stored as text into a real number. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

VALUE(text)

What people get wrong

Numbers that arrive as text from an export do not add up until VALUE, or a multiply by 1, converts them.

Google Sheets exercise that use VALUE

• Pull out the invoice numberLevel 5Pro

Often used together with: REGEXEXTRACT