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

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

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

Hi Mike,

Many thanks for this. This will really help automate my cheque-writing

regards,
Tony

"Mike" wrote:

This function will do it but you will have to change the text dollars/cents
to pounds/pence

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

Mike

"TONY M" wrote:

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