Getting the text value from a number

Javier · Aug 6, 2003

Need to get the text value from a cell that has a number
value, example 50 in cell A2, need to get in B2 "fifty"

is this possible using excel

Orlando Magalhães Filho · Aug 6, 2003

Hi Javier,

You have to define a function to this. Look for "VBA spell numbers function"
at this site:
http://cpap.com.br/orlando

HTH

terry · Aug 6, 2003

I would create a lookup table, obviously depending on the
possible range of numbers being manageable.