Converting number to text

[Jim]

is there a function or macro to convert a number in a cell
to text? For example, if I enter '536' I want another
cell to read 'five hundred thirty six'.
Thnks in advance!

 

[Orlando Magalhães Filho]

Hi Jim,

Look for "VBA spell numbers function" at this site:
http://cpap.com.br/orlando

The code spells number with or without unit as argument and it spells
fraction part in three ways.

HTH