how do i build commas on numbers in india system

[Vijay]

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]

"Vijay" <Vijay@discussions.microsoft.com> wrote in message
news:EB7E2F4B-F034-4BEE-8D59-EE1706FCC9AD@microsoft.com...
> 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)