Forum Discussion
Number formating
Hi all,
I am trying to change the number format from 1,00,000 to 100,000 without changing regional settings. could anyone please help in providing the code that needs to be updated in the custom value in format cells option.
1 Reply
In recent versions of Excel, you cannot override the regional settings in a custom number format.
It would be possible to use a formula to display the value using western format in another cell.
