When we type the numeric values upto 5 digits, Indian Rupees and USD have the same number of sequence except the symbol. But when it is more than 5 digits, then USD should be displayed like $ 123,456 and Indian Rupees should be Rs 1,23,456. But In both the cases, it is displaying the same way. I tried to change through Custom format. But not able to do this. How this can be corrected. Sample data attached.
8.9 KB Views: 2