ExcelBanter - change figure to text

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change figure to text (https://www.excelbanter.com/excel-discussion-misc-queries/10411-change-figure-text.html)

randall1000

change figure to text

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

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

Peo Sjoblom

See:

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

Regards,

Peo Sjoblom

"randall1000" wrote:

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

Jason Morin

See:

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

HTH
Jason
Atlanta, GA

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

All times are GMT +1. The time now is 09:36 AM.