ExcelBanter - How do I write a formula to convert numbers to written text?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I write a formula to convert numbers to written text? (https://www.excelbanter.com/excel-worksheet-functions/85107-how-do-i-write-formula-convert-numbers-written-text.html)

Jess

How do I write a formula to convert numbers to written text?

I want to write a formula or figure out how to have a cell containing 1,000
and to have a corresponding cell to reflect the written text form example
"One Thousand"

Bondi

How do I write a formula to convert numbers to written text?

Hi Jess,

Have a look at this link

http://www.meadinkent.co.uk/xlnumberstext.htm

Regards,
Bondi

Ron Coderre

How do I write a formula to convert numbers to written text?

Try this website:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Jess" wrote:

I want to write a formula or figure out how to have a cell containing 1,000
and to have a corresponding cell to reflect the written text form example
"One Thousand"

All times are GMT +1. The time now is 05:46 AM.