Assuming you have complete freedom in the choice of letters, use Roman
Numerals:


if A1 contains 10, then ROMAN(A1) would show X
--
Gary's Student


"Albert" wrote:

Hi everyone I need to translate numbers into letters using an excel macro.
Any idea on how to do so?