change figure to text

[randall1000]

Hi,
For example in cell A1 i have entered --12
want in cell A2 to appear --twelve
how do i do this?

 

[Ron de Bruin]

See Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[Peo Sjoblom]

See:

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


Regards,

Peo Sjoblom

 

[Jason Morin]

See:

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

HTH
Jason
Atlanta, GA