number to text

[yee388]

Just a shot in the dark... has anyone ever been able to get "one" from 1? ie in A1 you have entered 1, and in B1 you have =(magic formula(A1)) that returns "one"?

 

[Brian from Maui]

With the Morefunc addin,

=NUMTEXT(A1),

For code, there's lots on this board, there's also

www.asap-utilities.com

 

[plettieri]

Hi;

There is a bunch of stuff in ASAP Utilities that does number conversions to text....Is that what you had in mind?

plettieri

 

[yee388]

I think that I need that "morefunc" addon... where do I get it and how much?

 

[Brian from Maui]

It's FREE, so is ASAP,

http://www.mrexcel.com/board2/viewtopic.php?t=49750