DecToAlpha ( decimal )
Returns the representation of a decimal number as a variable-length alphabetic text string.
Average rating: 4.2 (45 votes) Log in to vote
*COMMENT Visual Realisation
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns the representation of a decimal (base-10) number as a variable-length alphabetic text string, similar to the column headings in Excel: A, B, C ... Z, AA, AB ... AZ, BA, BB ... ZZ, AAA, AAB ... ZZZ, AAAA, AAAB, etc.
DecToAlpha expects numbers to start at 0 (zero). In other words, DecToAlpha (0) returns "A", while DecToAlpha (1) returns "B". If your numbers start at 1, and you want the number 1 to be represented as "A", use DecToAlpha (decimal - 1).
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.