how to get grand total in words in excel sheet

[gangadhar]

please give some examples

 

[Luke M]

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)

 

[Gord Dibben]

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