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