formula to change figures into words
 

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!

--
Dave H

formula to change figures into words
 

Hi,

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

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

Mike

"Dave Hebert" wrote:

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!

--
Dave H

formula to change figures into words
 

A Function rather than a Formula, but try this

http://support.microsoft.com/default...b;en-us;213360

Mike

"Dave Hebert" wrote:

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!

--
Dave H

formula to change figures into words
 

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)



"Dave Hebert" wrote in message
...
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!

--
Dave H