need change the number format

[gajendra]

hi
i am finding it difficult to change the number in excel to indian
standard.
when i give input as 123456789 it is giving 123,456,789.00
but i need the number to be as 12,34,56,789.00
few more example
input output needed
123456 1,23,456.00
1234567 12,34,567.00
i want the number should change for whole spreedsheet. is it possible
by changing the custom number format or need i write macro..
please if u find solution for this reply me.

 

[somethinglikeant]

select all the cells you want to format

press ctrl+1

select custom and paste or type the following into the text field on
the right

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

for more injfo do a search on these groups on indian number format


somethinglikeant