Hi bob,

many thanks - This will stop me writing cheques with a different amout in
figures to words

Tony

"Bob Phillips" wrote:

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

--
---
HTH

Bob

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



"TONY M" <TONY wrote in message
...
I want to atomatically turn £10,123.45 into ten thousand, one hundred and
twenty-three pounds and forty-five pence but have no idea how to. Can any
one
help?

regards
Tony M