Digits to character...!!!

[usm]

Hi 2 all,

I have a figure (e.g 2755$) in a cell. i want this figure automatically
in words in any other cell (e.g twenty seven hundred and fifty five).

Is there any kind assistance...
Thanx

 

[Light]

Not my answer, but I found it in another post here

 

[mudraker]

Another site that has vba code to convert numbers to text

http://www.ozgrid.com/VBA/ValueToWords.htm