ExcelBanter - How can I write for extensive a number (Excel) ?

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

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

- - How can I write for extensive a number (Excel) ? (https://www.excelbanter.com/excel-worksheet-functions/66421-how-can-i-write-extensive-number-excel.html)

Carlos Santos

How can I write for extensive a number (Excel) ?

In cell (a1) I have a number: 156

In cell (c1) I have : (one hundred fifty six)

If cell a1 is modified, cell c1 will be modified as well.

Ron Coderre

How can I write for extensive a number (Excel) ?

If I understand you correctly, you want a formula in C1 which will translate
the number in A1 into words.

If that is correct, see this website:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

Does that help?

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

XL2002, WinXP-Pro

"Carlos Santos" wrote:

In cell (a1) I have a number: 156

In cell (c1) I have : (one hundred fifty six)

If cell a1 is modified, cell c1 will be modified as well.

Carlos Santos

How can I write for extensive a number (Excel) ?

"Ron Coderre" wrote:

If I understand you correctly, you want a formula in C1 which will translate
the number in A1 into words.

If that is correct, see this website:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

Does that help?

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

XL2002, WinXP-Pro

"Carlos Santos" wrote:

In cell (a1) I have a number: 156

In cell (c1) I have : (one hundred fifty six)

If cell a1 is modified, cell c1 will be modified as well.

All times are GMT +1. The time now is 01:25 AM.