Friends,
By default in Microsoft Excel has no feature regarding Indian Comma while entry any numeric value in excel. Excel shows value of Rs. 115515.00 as under :-
By default comma shows 115,515.00
Indian Format for Comma = 1,15,515.00
To take indian format in Excel, the following codes are entered in format as shown in below picture.
Open Excel >Select Column (as D in picture) > right click >Number >Custom > Type (paste below codes here) >OK
Code :- for Indian Format
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##00
|
