ExcelBanter - Converting number to text

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

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

- - Converting number to text (https://www.excelbanter.com/excel-discussion-misc-queries/125587-converting-number-text.html)

Markdb

Converting number to text

I need to convert a number eg (123) and need for it to appear as (ONE HUNDRED
TWENTY THREE) . ANybody can help me?

Ron de Bruin

Converting number to text

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Markdb" wrote in message ...
I need to convert a number eg (123) and need for it to appear as (ONE HUNDRED
TWENTY THREE) . ANybody can help me?

All times are GMT +1. The time now is 11:14 PM.