Excel

Colin Chapman · Dec 3, 2007

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 · Dec 3, 2007

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 · Dec 3, 2007

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

Excel

Colin Chapman

Pete_UK

FSt1