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
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.

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

    SergeiBaklan 

     

    Tried custom formatting but not solving the problem.

     

    I believe this setting shall be changed from windows, not from Excel.

     

    Same file and same amount in other computers displays in millions.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 09, 2020

      mafzalscanllccom 

      Perhaps you are right. When Win+R, control international, Ok, advanced and here

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

        Thank youSergeiBaklan 

         

        I am not from IT background. I am Estimation Engineer.

         

        How can I open the window you mentioned?

         

        Thanks.

Resources