ExcelFlux

DECIMAL function

Conversion — a text representation of a number in a given base into a decimal number.

Math and trigonometry · Excel 2013+

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Convert text in a selected base into a decimal number.

A worked example from the workbook

RowAB
6First valueSecond value
7FF16
810112
9158
Record 1
=DECIMAL(A7,B7)

Expected result255

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=DECIMAL("FF",16)
Turkish Excel · tr-TR
=ONDALIK("FF";16)

Expected result

255

Worked examples

Convert text in a selected base into a decimal number.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First value Second value
7 FF 16
8 1011 2
9 15 8
Case Formula Expected result
Record 1 =DECIMAL(A7,B7) 255
Record 2 =DECIMAL(A8,B8) 11
Record 3 =DECIMAL(A9,B9) 13
Microsoft Excel reference