Convert numeric values with decimals to alphabets

[kjxavier]

H!

I have a long list of Numeric like this ....
can you please help me to convert the numeric to alphabets in the specified format?



i.e:

742111.37
676736.06

=
SEVEN HUNDRED FORTY TWO THOUSAND ONE HUNDRED ELEVEN AND THIRTY SEVEN CENTS

SIX HUNDRED SEVENTY SIX THOUSAND SEVEN HUNDRED THIRTY SIX AND POINT SIX CENTS


NOTE: " AND POINT SIX CENTS means .06"


Your early reply is highly appreciated!

Thank you

[Winon]

Hello kjxavier,

The attached sample Workbook contains a formula for converting numbers to text, and it should give you a good start.

I will leave it up to you to try and tweak it in such a manner that the formula would return .06 as "Point Six Cents". I really don't know why you would want it to show as such.

Good luck.

Regards.

[cbatrody]

Please go through the following URL. This has a Macro based solution.

http://support.microsoft.com/kb/213360