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