Indian Comma Format in Excel

Sunday, January 30, 2011 | comments


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



[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00




Share this article :

to View TDS Links click below image

 
Support : Tds Tax India
Copyright © 2011. Tds Tax India - All Rights Reserved
Site Created by Tds Tax India