ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How realizes the following request (https://www.excelbanter.com/excel-worksheet-functions/121241-how-realizes-following-request.html)

无名

How realizes the following request
 
US$4963.28---“SAY TOTAL FOUR THOUSAND NINE HUNDRED AND SIXTY-THREE US
DOLLARS AND TWENTY-EIGHT CENTS ONLY"。
for example:
100 one hundred
101 one hundred and one
156 one hundred and fifty-six
200 two hundred
1,000 one thousand
1,001 one thousand and one
1,300 thirteen hundred;one thousand and three hundred
2,000 two thousand
2,034 two thousand and thirty-four
6,502 six thousand five hundred and two
38,000 thirty-eight thousand
45,672 forty-five thousand six hundred and seventy-two
500,000 five hundred thousand
1,000,000 one million




--
请查收邮件!



Bob Phillips

How realizes the following request
 
See response in public.excel

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"无名" wrote in message
...
US$4963.28---“SAY TOTAL FOUR THOUSAND NINE HUNDRED AND SIXTY-THREE US
DOLLARS AND TWENTY-EIGHT CENTS ONLY"。
for example:
100 one hundred
101 one hundred and one
156 one hundred and fifty-six
200 two hundred
1,000 one thousand
1,001 one thousand and one
1,300 thirteen hundred;one thousand and three hundred
2,000 two thousand
2,034 two thousand and thirty-four
6,502 six thousand five hundred and two
38,000 thirty-eight thousand
45,672 forty-five thousand six hundred and seventy-two
500,000 five hundred thousand
1,000,000 one million




--
请查收邮件!






All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com