In our world there are many countries and have different formats for Date and Currency.
Like Britishers have dd/MM/yyyy date format and Americans prefer MM/dd/yyyy format whereas ISO recommends yyyy/mm/dd format. But since Microsoft is America based, All computer are default set to MM/dd/yyyy date format.
Same with Currency format. Every country has it's own Currency Recognition Symbol and Comma/Decimal Separators.
Like in India ones,tens, hundred (3) are grouped in first comma place and Thousand and Bigger amounts are grouped in 2 comma places (1,23,45,67,890.00) but in American and some other patters all the numbers are grouped in 3 (1,234,567,890)
In Europe Commas are used to separate to decimals, and decimal is used as comma.
It is enough that laid Microsoft to provide flexibility in his operating systems to change the number and date systems as per Regional location.
How can one change these settings....?
Open Control Panel - Double Click on Regional and Language Options
It is recommended that AT Regional Options Tab Firstly select the Location (your country name)
Click on Customize
1. in Numbers tab you can Set Decimal Symbol (generally "."), Digit Grouping Symbol (generally ","), Digit Grouping (Select 3,3 or 2,3 Pattern), and other options
2. in Currency Tab you can Provide the Currency Symbol and Digit Grouping and other Options.
3. in Date tab - Short Date format Specify your desired date format. (it is very important to enter the pattern correctly, because Excel and other applications that refer Windows Date Format shall recognize and convert the date in format Specified by you in Short Date format)
Save the settings now Run Excel and Check the Settings. How effectively it works and how flexible it is.
Like Britishers have dd/MM/yyyy date format and Americans prefer MM/dd/yyyy format whereas ISO recommends yyyy/mm/dd format. But since Microsoft is America based, All computer are default set to MM/dd/yyyy date format.
Same with Currency format. Every country has it's own Currency Recognition Symbol and Comma/Decimal Separators.
Like in India ones,tens, hundred (3) are grouped in first comma place and Thousand and Bigger amounts are grouped in 2 comma places (1,23,45,67,890.00) but in American and some other patters all the numbers are grouped in 3 (1,234,567,890)
In Europe Commas are used to separate to decimals, and decimal is used as comma.
It is enough that laid Microsoft to provide flexibility in his operating systems to change the number and date systems as per Regional location.
How can one change these settings....?
Open Control Panel - Double Click on Regional and Language Options
It is recommended that AT Regional Options Tab Firstly select the Location (your country name)
Click on Customize
1. in Numbers tab you can Set Decimal Symbol (generally "."), Digit Grouping Symbol (generally ","), Digit Grouping (Select 3,3 or 2,3 Pattern), and other options
2. in Currency Tab you can Provide the Currency Symbol and Digit Grouping and other Options.
3. in Date tab - Short Date format Specify your desired date format. (it is very important to enter the pattern correctly, because Excel and other applications that refer Windows Date Format shall recognize and convert the date in format Specified by you in Short Date format)
Save the settings now Run Excel and Check the Settings. How effectively it works and how flexible it is.
