Numbers

[Thad Hollingshead]

I would like to do the following...

Lets say A1 = "10"

I would like B1 to = "ten"

Can this be done??


Thanks in advance for your help.

 

[J.E. McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords