Math & Trig
Excel 2013
◉ 21 views
=DECIMAL()
Converts a text representation of a number in a given base into a decimal number.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=DECIMAL(text, radix)
Hover argument names in the table for details.
Output typeNumber
Popularity5 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =DECIMAL() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
text |
Text | Required | نمایش متنی عدد در مبنای موردنظر. |
radix |
Number | Required | Radix must be an integer. |
▣ Examples
Example 1
=DECIMAL("FF", 16)
Example 2
=DECIMAL("1010", 2)
§ Remarks
- The string length of Text must be less than or equal to 255 characters.
- The Text argument can be any combination of alpha-numeric characters that are valid for the radix, and is not case sensitive.
- Excel supports a Text argument greater than or equal to 0 and less than 2^53. A text argument that resolves to a number greater than 2^53 may result in a loss of precision.
- Radix must be greater than or equal to 2 (binary, or base 2) and less than or equal to 36 (base 36). A radix greater than 10 use the numeric values 0-9 and the letters A-Z as needed. For example, base 16 (hexadecimal) uses 0-9 and A-F, and base 36 uses 0-9 and A-Z.
- If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value.
✦ Tips
- The string length of Text must be less than or equal to 255 characters.
- The Text argument can be any combination of alpha-numeric characters that are valid for the radix, and is not case sensitive.
- Excel supports a Text argument greater than or equal to 0 and less than 2^53. A text argument that resolves to a number greater than 2^53 may result in a loss of precision.
- Radix must be greater than or equal to 2 (binary, or base 2) and less than or equal to 36 (base 36). A radix greater than 10 use the numeric values 0-9 and the letters A-Z as needed. For example, base 16 (hexadecimal) uses 0-9 and A-F, and base 36 uses 0-9 and A-Z.
⚠ Common Errors
#NUM!
If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value.
Fix: Check the base and the text characters
#VALUE!
If either argument is outside its constraints, DECIMAL may return the #NUM! or #VALUE! error value.
Fix: بررسی کنید Text فقط شامل نویسههای مجاز مبنا باشد و Radix مقدار عددی معتبر باشد.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!