Forum Discussion
Changing Million Comma
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.
- SergeiBaklanSep 09, 2020Diamond Contributor
- mafzalscanllccomSep 09, 2020Copper Contributor
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.
- SergeiBaklanSep 09, 2020Diamond Contributor