Forum Discussion

mafzalscanllccom's avatar
mafzalscanllccom
Copper Contributor
Sep 09, 2020

Changing Million Comma

Hello,

 

I am working in MS Excel. My system shows amount 10,00,000.00; which I want to change to 1,000,000.00.

 

How can I change it in display and print?

 

Thanks.

excel

8 Replies

Sort By
    • mafzalscanllccom's avatar
      mafzalscanllccom
      Copper Contributor
      Sep 09, 2020

      Hello SergeiBaklan

       

      Thank you for your response but solution is not what I am looking for.

       

      For Example I am writing an amount of one million, it is showing 10,00,000.00.

       

      This is perfect when you are working for Indian Rupees, because the amount in India is calculated and spoken in Lakhs or Crores. Above mentioned amount shall be called 'Ten Lakhs' instead of 'One Million'.

       

      Whereas in US and other areas, where counting in Millions in practice, its written 1,000,000.00 and spoken 'One Million.

       

      However both numbers are same.

       

      I hope this has clarified my Query.

       

      Thanks.

Resources