Skip to main content
Sign in

Decimals appear as Commas When importing an Excel XLS into a Target Drillhole project.

Permanently deleted user
  • Updated

Symptom:

When Importing an Excel XLS into Target using the following method the decimals in the Excel spreadsheet appear as commas in Target.

  1. DH-Data > New project > New Empty Project
  2. DH-Data > Import Data > XLS/Database
  3. Using the wizard go to "From To data" and changed the From-to View to the sheet with the weight data.
  4. Set "channel to import" as channel type: Data
  5. Set data type as "sting"
    Note that the Channel is imported as string with commas.
  6. Repeating steps 1-4 I set the data type as "floating point"

Note that the Channel is imported as floating point with dummies in place of the values that had decimals.


Resolution:
The problem lies in the Windows language settings. In some regions, such a Europe, the default for "Decimal Symbol" is set to ",". Geosoft applications will convert the decimal to comma, but not use the comma as a decimal.

To resolve this In Windows 10 (64 bit):

  1. Go to "Control Panel"
  2. Click "Change date, time, or number formats
  3. On the "Formats" tab click "Additional settings"
  4. On the "Numbers" tab enter make sure the "Decimal symbol" is "." if not, change it to "."
  5. Click "Apply"

Reimport the XLS into your target project.