Tutorial Application




  • Home
  • Mobile & Apps
  • Computer
  • How to
  • Software
  • Windows

how to change default decimal separator in Windows 10

how to change default decimal separator in Windows 10 – This solution will help when a client tries to import a report from a CSV file and appears in the first column. when you open the csv file sometimes the format becomes cluttered, it can’t be read, because the decimal separator format is different from the csv format that you downloaded.

You can change the default decimal separator in Windows 10, to adjust the format you need. for example, a comma becomes a semicolon. to change it in Windows 10 is very easy you can follow the steps below.

In addition to CSV, in processing data using Microsoft Office Excel we also need to pay attention to the language settings or regional settings of the computer that we use. Because this will affect the way we write excel formulas and functions in Microsoft Excel. In addition this regional setting will also affect how the display format of numbers, currencies and dates in the data that we process.

how to change default decimal separator in Windows 10

  1. Please open the Control Panel menu, by clicking on the Windows 10 search feature then typing Control PanelHow to open Control Panel Windows 10
  2. then in the Clock and Region menu click underneath Change date, time or number formats
  3. Then in the TAB formats, click the Additional settings button
    Additional settings menu Windows 10 SETTINGS
  4. In the Decimal Symbol column, replace with periods (.) then List Separator, please replace it with comma (,). Usually for CSV, the separator usually uses a dot or semicolon to adjust your needs.
    Decimal symbol and list separator WINDOWS 10
  5. Then please click the OK button

 

Thus how to change the default decimal separator in Windows 10, may be useful for you.

How to download language pack and change language Windows 10 OSHow To change default browser Windows 10 to chrome

Leave a Reply Cancel reply

Recent Posts
  • Again ! Southwest Airlines Cancels Thousands of Flights
  • How to Downgrade Windows 11 to Windows 10 If It’s Still Not Comfortable
  • How to Connect Google Calendar With the Calendar App on Windows 11
  • Dynamic Lock in Windows 11 Troubled? Try These 4 Tips!
  • How to Add Windows 11 22H2 Desktop Sticker
Popular Posts
  • How to Save Files From VN Video Editor Application To The Gallery
  • How to sync folder google drive with Desktop PC
  • Failed to Install CorelDRAW x8 error (The installation was not completed)
  • Install whatsapp messenger free download for samsung galaxy
  • How to send email from android phone
Categories
  • Computer
  • Download & Install
  • How to
  • Mobile & Apps
  • News
  • Software
  • Uncategorized
  • Windows




2023 © Tutorial Application
Grimag theme by StrictThemes