ExcelBanter - How I can get "Two Hundreds and Twenty" if i type "220" in a cell

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

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

- - How I can get "Two Hundreds and Twenty" if i type "220" in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/244010-how-i-can-get-two-hundreds-twenty-if-i-type-220-cell.html)

AHASAN

How I can get "Two Hundreds and Twenty" if i type "220" in a cell

Bob Phillips[_3_]

How I can get "Two Hundreds and Twenty" if i type "220" in a cell

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
__________________________________
HTH

Bob

"AHASAN" wrote in message
...

Bob I

How I can get "Two Hundreds and Twenty" if i type "220" in acell

How to convert a numeric value into English words in Excel
http://support.microsoft.com/kb/213360

AHASAN wrote:

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