ExcelBanter - reading currency/number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - reading currency/number (https://www.excelbanter.com/excel-discussion-misc-queries/1909-reading-currency-number.html)

whitesnow

reading currency/number

Could you please tell me how can I read the numbers/currencies automatically.
Say, if I put a currency like 5.000 in A1, cell A2 can show me the reading in
words like five thousand dollars. Many thanks.

Frank Kabel

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Regards
Frank Kabel
Frankfurt, Germany

whitesnow wrote:
Could you please tell me how can I read the numbers/currencies
automatically. Say, if I put a currency like 5.000 in A1, cell A2 can
show me the reading in words like five thousand dollars. Many thanks.

All times are GMT +1. The time now is 10:16 AM.