Format numbers from Lakhs to millions

[Dattathreya Sawant]

Hi,

I work in finance department and my reporting is in India and overseas.

Is there any way i can format the cells "," to millions. If i change the regional setting all worksheet becomes in millions and it will be difficult for India reporting.

As now in excel 10,00,000 to 1,000,000 display with any formula or a custom formatting.

 

[kranthi157]

Hi Dattathreya,

It is easy. Select the cell that you want to format. Right click on the cell highlighted. Select the format Cell option.. You will get the below widget.
Hope this helps.