formula to change figures into words

[Dave Hebert]

1) I bid projects that require me to list hundreds of unit prices in "BOTH"
words and figures. I know there's a formula that can create the figures "in
words" from a numerical cell value, but can't find it. Help save me from
writer's cramp!

 

[Mike H]

Hi,

There's lots of them and this is as good as any.

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

 

[mikebres]

A Function rather than a Formula, but try this

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

Mike

 

[Bob Phillips]

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)