Anyone know how I can convert numbers to text? I’m after just converting cells containing number 0 to 25, in the letter a to z. I had assumed there would be a function called DEC2ASCII or similar, but can’t find it.

cheers in advance.

TEXT

So using TEXT, what is the format_text to do the conversion of a number to a letter?

Ah, ok worked it out. CHAR() is where its at. Thanks Jam bo.

to get the numbers to appear as letters you can probably use the ‘char’ function.

for 0 to be lowercase a then you should be able to use
=char( number + 97 )

=CHAR(64+A1) where the number is in cell A1
There may be other ways

Too slow by 8 secs
Goes off to end it all

Ah yeah. Didn’t read the requirement spec properly…