Currency to text
 

I have a column with a list of numbers in currency format (No decimal places)
i.e £168,995. Is it possible to automaticaly convert this in excel to text,
i.e. One Hundred and Sixty Eight Thousand Nine Hundred and Ninety Five
Pounds, if so how?

Thank you

Currency to text
 

http://xldynamic.com/source/xld.xlFAQ0004.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Caspar" wrote in message ...
|I have a column with a list of numbers in currency format (No decimal places)
| i.e £168,995. Is it possible to automaticaly convert this in excel to text,
| i.e. One Hundred and Sixty Eight Thousand Nine Hundred and Ninety Five
| Pounds, if so how?
|
| Thank you