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