Hi,Hi,
i think this will work:
[>=1000000]###\,##0;General
See more at Hui's Thread:
http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/
Hi,
This not working for me.
I required format in 1,234,567.00
Excel 2013 only shows a comma after the thousands and not after millions , so 1234567 would show as 1234,567 and not 1,234,567.
Hi Khalid ,
The problem is what you have posted ; the full sentence from the original post is :
So at present , 1234567 is showing as 1234,567 , with the comma acting only as the thousands separator , and not after every group of 3 digits ; Pinang wants that it should act as a grouping separator , so that 1234567 would be displayed as 1,234,567.
Narayan
Dear Sir,Hi Jitendra ,
Can you change your Windows setting and recheck ?
Narayan
Dear Sir,
Please see this the setting of my system yet...