formula to change figures into words

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Hebert - 21 May 2008 19:39 GMT

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!

Signature

Dave H

Reply to this Message

Mike H - 21 May 2008 19:49 GMT

Hi,

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

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

Mike

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

Reply to this Message

mikebres - 21 May 2008 19:54 GMT

A Function rather than a Formula, but try this

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

Mike

Reply to this Message

Bob Phillips - 21 May 2008 20:21 GMT

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

Signature

---
HTH

Bob

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

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

Reply to this Message