Getting the text value from a number

[Javier]

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]

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]

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