SpellNumber

[George]

Hi All,

How do I make Excel spell a number in a cell?

i.e. - If I want cell A1 to display in words the number
in A2, how do I get A1 to display 'Three' if A2
displays '3'?

Kind Regards,

George.

 

[drabbacs]

You could do a lookup to a range that contains word
equivalents of your numbers.

in A1 =vlookup(a2,range,2,"false")

where range is an area that looks like

1 one
2 two
3 three
..
..
..
465 four hundred sixty-five

Basically say take whatever is in a2 and find that entry
in the first column of the range and return the
corresponding information from the second column.