Expressing a number as a string of text

[Drew]

Is there a way to enter a number, for example 35,231.00, and create the following text "thirty five thousand two hundred thirty one"?

I tried to search the archives because I seem to remember someone asking a similar question. (couldn't find it though)

Thanks in advance.
Great site.
Drew

 

[Juan Pablo González]

Here is that question (And Barrie's answer)

http://www.mrexcel.com/wwwboard/messages/23156.html

 

[Drew]

Thanks Juan. Exactly what I needed.

Drew