DECIMAL

DECIMAL(value, radix)

Returns the decimal number of a text representation of a number in a given base.

valueThe text representation of a number.
radixThe base.

REMARKS
* This function is not case sensitive.
* The string length of "value" must be less than or equal to 255 characters.
* The "value" can be any combination of alpha-numeric characters that are valid for the radix, and is not case sensitive.
* A decimal that is greater than 2^53 may result in a lack of precision.
* You can use the BASE to return the number converted into a text representation with the given base.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=DECIMAL("Monday", 36) = 1371656986
2=BASE(A1, 36) = MONDAY
3=DECIMAL(100, 10) = 100
4=DECIMAL(100, 100) = #NUM!

1 - Base 26 (alphabet characters) + 10 (0-9)

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top