Excel

[Colin Chapman]

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

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[FSt1]

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