VALUE practice

VALUE converts a number stored as text into a real number. Below are the 1 Excel exercise on Formuladrill 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.

Excel exercise that use VALUE

• Numbers stored as textLevel 6Pro

Often used together with: SUM