Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
DECIMAL
Converts text in a given base back to a decimal number.
Rarely usedDifficulty 1250 · ProficientUsage rank #280 of 520
When to use it
Converts text in any base (2 to 36) back to a decimal number.
The shape of it
- Syntax
=DECIMAL(text, radix)
Worked examples
Binary
=DECIMAL("1010",2) → 10
Binary to decimal.
Hex
=DECIMAL("FF",16) → 255
Hex to decimal.
Base 36
=DECIMAL("zz",36) → 1295
Base 36, case insensitive.
Worth knowing
- Pair with BASE for round trips.
- Handles longer inputs than HEX2DEC (up to 255 characters).
- Digits must be valid for the base or the result is #NUM!.
Where it goes wrong
- #NUM! when a character is not valid in the base.
- Whitespace inside the text is not allowed.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.