DECIMAL

DECIMAL(text, radix)

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

textThe text representation of a number.
radixThe base.

REMARKS
* This function is not case sensitive.
* If "text" > 255 characters, then ??
* 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
* For the Google documentation refer to support.google.com

 A
1=DECIMAL("Monday", 36) = 1371656986
2=BASE(A1, 36) = MONDAY

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

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