Have a look here for some examples of how to do it:

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

Hope this helps.

Pete

On Dec 3, 11:35 am, Colin Chapman
wrote:
I want to know how to convert a cell to a number

When I do my expenses column N36 calculates the sum of the claim

eg £1246.78
in cell D40 I have to write the total in words

Can I get a formula to do this automatically?

Any help please

Colin