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


gajendra wrote:
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.


--
gajendra
------------------------------------------------------------------------
gajendra's Profile: http://www.excelforum.com/member.php...o&userid=35739
View this thread: http://www.excelforum.com/showthread...hreadid=555210