i want excel to read the amount (no. format-20,000.00) and print .
 

I have created a invoice format in excel using IF LOOPS.
And the amount is calculated in number format (example: 12,000.00) and i
want excel to read it and convert it into the word format (example: Twelve
thousand) and print it in a different column on screen.

i want excel to read the amount (no. format-20,000.00) and print .
 

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Rajiv Madan" <Rajiv wrote in message
...
I have created a invoice format in excel using IF LOOPS.
And the amount is calculated in number format (example: 12,000.00) and i
want excel to read it and convert it into the word format (example: Twelve
thousand) and print it in a different column on screen.