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

[Carlos Santos]

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]

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]

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