Int2Alpha ( Integer )
Rate this function: Average rating: 2.8 (16 votes)
Discuss this Custom Function
JT Hughes, Queuedom
http://notapplicable.com
Converts an integer to its alphabetic equivalent
Sample Input:
| Reverse ( Int2Alpha ( 745 ) ) |
|
Sample Output:
|
Description:
// SAMPLE CONVERSION FOR Integer = 1234
// FIRST ITERATION
// Letter = Mod ( 1234 - 1 ; 26 ) + 1 = 12 -> "L"
// Integer => Div ( 1234 - 1 ; 26 ) = 47
// SECOND ITERATION
// Letter &=> Mod ( 47 - 1 ; 26 ) + 1 = 21 -> "U"
// Integer => Div ( 47 - 1 ; 26 ) = 1
// THIRD ITERATION
// Letter &=> Mod ( 1 - 1 ; 26 ) + 1 = 1 -> "A"
// Integer => Div ( 1 - 1 ; 26 ) = 0
// Letters = "LUA"
// Reverse( "LUA" ) => "AUL"
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|
