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

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

hi
see these sites. not a real easy way to do this but it is possible.
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.sulprobil.com/html/spellnumber.html
http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/?kbid=213360

regards
FSt1

"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