how to get grand total in words in excel sheet
 

please give some examples

how to get grand total in words in excel sheet
 

What exactly do you want?

2
3
0
0
0

="Grand total equals "&sum(A1:a5)
would give you a cell displaying "Grand total equals 5"

If you want a total of words in a column, say "cat"
=COUNTIF(A1:A5,"cat")
would tell you how often the word "cat" appears. (0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gangadhar" wrote:

please give some examples

how to get grand total in words in excel sheet
 

You mean like 3333.33 should be

Three Thousand Three Hundred And Thirty Three Dollars And Thirty three Cents

See Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 12:06:08 -0800, gangadhar
wrote:

please give some examples