how do i build commas on numbers in india system

V

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
 
B

Bob Phillips

Vijay said:
1. How do I put comas in numbers under Indian sytem?
Click to expand...

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?
Click to expand...

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
Click to expand...

Use the RANK function

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