SpellNumber

  • Thread starter Thread starter George
  • Start date Start date
G

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.
 
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.
 
Back
Top