When working on Excel, by default, if you use numbers, you will notice that thousands are separated by commas (,) and decimal points by periods (.). This display method is opposite to how we usually write, so sometimes it can lead to misunderstandings. In this article, Mytour will share with you how to change periods to commas in Excel.
Usually, users will change periods to commas on Windows 7, XP depending on the operating system they use before installing and using Excel. This will save you a lot of time. However, setting it up within the Excel 2007 program also helps you fix that error.
Guide to Changing periods to commas in Excel 2007
Get the latest version of Excel 2007
Step 1: Open the Excel file and go to Excel Options
Step 2: A window will pop up, here, find and click on the Advanced option
Step 3: Under the Editing Options:
