Changing Million Comma

[mafzalscanllccom]

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.

[#2]

@mafzalscanllccom 

If that's not text please Ctrl+1 on cell and check your format, is it as here?

[#3]

Hello @Sergei Baklan

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.

[#4]

@mafzalscanllccom 

You may apply custom format as

[#5]

@Sergei Baklan 

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.

[#6]

@mafzalscanllccom 

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

[#7]

Thank you@Sergei Baklan 

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

How can I open the window you mentioned?

Thanks.

[#8]

@mafzalscanllccom 

Press Win and R buttons. Here type

Press Ok.

On next window

Here select proper digital grouping

and apply

[#9]

@Sergei Baklan Still not happening