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.