Function like this available?

[Kelie]

Hello,

In Excel (2003 and 2007), is there a built-in function that will
convert a dollar amount to text, i.e. convert "$15,340" to "Fifteen
Thousand Three Hundred and Forty", or something like this.

Thanks,

Kelie

 

[Bob Umlas]

See http://support.microsoft.com/kb/213360
You need a user-defined function to do this.

 

[Bob Phillips]

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

 

[Kelie]

Thanks a lot, Bob and Bob!

 

[Gord Dibben]

No built-in Function in 2003 and earlier for sure.

See Bob Phillips' site for numbers to words methods.

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


Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

Also known as the "Roberts" <vbg>


--


Regards,


Peo Sjoblom

 

[Bob Umlas]

Maybe Robby the robot?

Also known as the "Roberts" <vbg>


--


Regards,


Peo Sjoblom

 

[Bob Phillips]

No ... it is Bob U and Bob Me.