Changing Million Comma

%3CLINGO-SUB%20id%3D%22lingo-sub-1647856%22%20slang%3D%22en-US%22%3EChanging%20Million%20Comma%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647856%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20in%20MS%20Excel.%20My%20system%20shows%20amount%2010%2C00%2C000.00%3B%20which%20I%20want%20to%20change%20to%201%2C000%2C000.00.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20change%20it%20in%20display%20and%20print%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1647856%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647897%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20Million%20Comma%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647897%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786994%22%20target%3D%22_blank%22%3E%40mafzalscanllccom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that's%20not%20text%20please%20Ctrl%2B1%20on%20cell%20and%20check%20your%20format%2C%20is%20it%20as%20here%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20496px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217282iFBB0F502DCC81D0F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647920%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20Million%20Comma%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647920%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response%20but%20solution%20is%20not%20what%20I%20am%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Example%20I%20am%20writing%20an%20amount%20of%20one%20million%2C%20it%20is%20showing%2010%2C00%2C000.00.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20perfect%20when%20you%20are%20working%20for%20Indian%20Rupees%2C%20because%20the%20amount%20in%20India%20is%20calculated%20and%20spoken%20in%3CSTRONG%3E%20Lakhs%20or%20Crores.%20%3C%2FSTRONG%3EAbove%20mentioned%20amount%20shall%20be%20called%20%3CSTRONG%3E'Ten%20Lakhs'%3C%2FSTRONG%3E%20instead%20of%20%3CSTRONG%3E'One%20Million'.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhereas%20in%20US%20and%20other%20areas%2C%20where%20counting%20in%20Millions%20in%20practice%2C%20its%20written%201%2C000%2C000.00%20and%20spoken%20%3CSTRONG%3E'One%20Million.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20both%20numbers%20are%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20has%20clarified%20my%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

7 Replies

@mafzalscanllccom 

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

image.png

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.

@mafzalscanllccom 

You may apply custom format as

image.png

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

@mafzalscanllccom 

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

image.png

Thank you@Sergei Baklan 

 

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

 

How can I open the window you mentioned?

 

Thanks.

@mafzalscanllccom 

Press Win and R buttons. Here type

image.png

Press Ok.

On next window

image.png

Here select proper digital grouping

image.png

and apply