Currency Amounts

[Johnners]

I need to convert $123,456.78 to words eg: One Hundred and Twentythree
Thousand Four Hundred and Fifty Six Dollars and 78 Cents

Any ideas ??

 

[David McRitchie]

Hi Johnners,
See http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords
for some links You may want to try more than one as the US places
"and" only to denote a decimal place and UK uses "and" at additional
points -- just in case you. the MS KB articles look the same.