ExcelBanter - any formula to convert numbers in word form, e.g. "2" as "Two"?

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

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

- - any formula to convert numbers in word form, e.g. "2" as "Two"? (https://www.excelbanter.com/excel-worksheet-functions/188847-any-formula-convert-numbers-word-form-e-g-2-two.html)

Neeraj

any formula to convert numbers in word form, e.g. "2" as "Two"?

Is there any formula to convert the numerical in word form?

Such as i want to write

A B C D E
F
1 12 "Twelve"

What formula or format should be set in such a case?

Please help me.

Niek Otten

any formula to convert numbers in word form, e.g. "2" as "Two"?

Look here for several solutions:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Neeraj" wrote in message ...
| Is there any formula to convert the numerical in word form?
|
| Such as i want to write
|
| A B C D E
| F
| 1 12 "Twelve"
|
| What formula or format should be set in such a case?
|
| Please help me.
|

All times are GMT +1. The time now is 05:06 PM.