how do i build commas on numbers in india system

[Guest]

1. How do I put comas in numbers under Indian sytem?
2. Is it possible to view the header and footer on the excel spread sheet
screen?
3. How to get rank in a given table

 

[Bob Phillips]

1. How do I put comas in numbers under Indian sytem?

Use acustom format of

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

will format say 1234567890 as 123,45,67,890.00

2. Is it possible to view the header and footer on the excel spread sheet
screen?

Don't think so, but you can have headers in the spreadsheet and use them as
print headers, using File>Page Setup>Sheet and set the rows in the 'Rows to
repeat at top' textbox.

3. How to get rank in a given table

Use the RANK function

=RANK(A1,$A$1:$A$20)