MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting currency into words

Posted by Craig Bailey on May 15, 2001 8:36 PM

Can anyone help me convert a currency into words eg convert $125.45 into 'one hundred and twenty five dollars and forty five cents'?
Ideally it could handle the currency ie dollars, yen, pounds, lera etc, but this is a lower priority.
I imagine this would be a reasonably common requirement in accounting packages, so I wonder if I have missed an existing worksheet function. If not I will have to write a VBA function.

Posted by Kevin James on May 15, 2001 9:31 PM

Posted by Pail on May 16, 2001 4:02 AM