Attached please find the MS Excel file. In which there are two sheets. Nos_Words and Active_Sheet.
Sheet with the name Nos_Words has some sort of table to convert the numeric values into words. It is working fine. Like whatever the value is in C5 of the Active_Sheet, it converts it into the required wording. And then in Active_Sheet it displays the words from the F4 of Nos_Words sheet.
What i need to do is this, display the amount or numbers in Words in my whole list as shown in Active_Sheet. Please help!
I have tried the VBA sample code from the Microsoft site “Function SpellNumber” http://support.microsoft.com/kb/213360
but the attached sheet is close to my requirements.
Basically i am looking for a formula not VBA function to convert numbers into words as it is doing in the Nos_Words sheet of the attached file. However now i need to apply this on the whole list on the Active_Sheet.