Convert a number to a text string

[Sandy]

I want to convert a number like 12.56 to read Twelve Dollars and 56/100

 

[ryguy7272]

Of all the (applicable) resources on the web, this is probably the easiest to
digest:
http://www.xldynamic.com/source/xld.xlFAQ0004.html


Regards,
Ryan--

 

[Niek Otten]

Hi Sandy,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to convert a number like 12.56 to read Twelve Dollars and 56/100

 

[Sandy]

Thanks, I guess I'll wait til MS comes out with it

 

[Gord Dibben]

See Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP