in case anyone else needed it heres what i came up with.

Function numtoalphabet

Parameters nval

If nval < 27

retval = Chr(64+nchr)
Else

retval = CHR(64+INT(nval/26)) + CHR(64+ nval- 26 *INT(nval/26))

Endif
RETURN retval

Paul