surely you already know the And you know what they are separated from the integers by a punctuation mark. What you may not know is that in some regions a point is used and in others the comma.
For example, throughout Europe, except the United Kingdom, the point is usedwhile to separate the thousand comma. In the same way it happens in South Americawith the United States, Mexico, Canada and some Caribbean islands being the exception to the rule.
For this reason, if you must deliver a document to a region other than yours and does not use the same system, We recommend you pay attention to this post.
When is it necessary to change commas to periods in Microsoft Excel data tables?
As we mentioned before, not all countries use the same form of numbering. Moreover, in some African regions they have not defined a standard. For this reason, if you must send one or an excel chart to a location other than yours, It is recommended that you find out first which sign to use.
Programs that belong to office package, they take the writing mode of the system language and region. It is defined when we install Microsoft Windows. If your computer is in Spanishbut you want to use the write method english in Excelis a valid reason to change the comma to the period.
A common situation is thatwhen you download a spreadsheet from an external source such as the Internet, the same has been done in a different way which you are not used to.
For this and the previous cases, we will show you the following:
Steps to change commas to periods in your Microsoft Excel spreadsheets
There are two methods to perform the exchange between semicolons in the document of Excel. The first will affect only the program, while the second will affect the entire operating system.
Let’s see how to perform each of them:
- Start MS Excel.
- In the Homepagepress the button “Options”. It is located at the end of the side panel. You don’t need to create a blank workbook or open an existing one.
- In the pop-up window, locate and tap “Advanced”.
- In the section “Editing Options” you will find the box “Use system separators”when this is activated it will use the regional configuration of windows (which we will change in the second method).
- Deactivate this option and exchange the semicolon in the decimal and thousands separators as appropriate.
- To finish, press “To accept”.
a second way to do that, is change regional settings. This option is only recommended if you are going to use a different decimal separation system than permanently.
To do this, follow these steps:
- Click on Start and search “Control Panel”.
- Once this utility is open, select “Watch, language and region”.
- Of the following two options, choose “Region”.
- Go to the tab “Administrative”.
- Here will appear your idiom Y region currently used by the system.
- To change this, press “Change system regional settings”. You will need permits from administrator.
- In this window, choose the new arrangement of language and region.
- press “To accept” until leaving.
Note that this change will influence the entire operating system. For example, the way to write some symbols on the keyboard will be affected, as well as the default language of certain programs.
For undo these changesperform the same steps and use the configuration you used in the beginning.
Facebook Comments
Disqus