Converting currency from numeric format to words

[sharma]

How do I convert $10.25 to Dollars Ten and Twenty Five Cents? Thanks for the help

[Ivan F Moala]

On 2002-04-18 00:54, sharma wrote:
How do I convert $10.25 to Dollars Ten and Twenty Five Cents? Thanks for the help

I'm sure this has been covered on the board.
But Have a look here;

http://support.microsoft.com/default...;EN-US;q213360

http://support.microsoft.com/default...;EN-US;q140704

http://support.microsoft.com/default...b;EN-US;q95640

[sharma]

Thanks. The article in MS knowledge base is excellent and provides the solution.

[Aladin Akyurek]

Adding Ivan's list:

Longre's morefunc.zip contains NUMTEXT, a UDF, that does the job.