Convert a number to a text string
 

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

Convert a number to a text string
 

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--

--
RyGuy


"Sandy" wrote:

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

Convert a number to a text string
 

Hi Sandy,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sandy" wrote in message ...
|I want to convert a number like 12.56 to read Twelve Dollars and 56/100

Convert a number to a text string
 

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

"ryguy7272" wrote:

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--

--
RyGuy


"Sandy" wrote:

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

Convert a number to a text string
 

See Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP

On Thu, 3 Jan 2008 11:30:01 -0800, Sandy
wrote:

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