HomeWikiMacChanging Regional Setting in a MAC (CSV imports)

32.3. Changing Regional Setting in a MAC (CSV imports)

This solution will assist where clients are trying to import reports from a CSV file and they appear on the first column:

For Mac OS version 10.7.4, please follow these instructions:

  1. Close the Excel application
  2. Click on the Apple button
  3. Select System Preferences
  4. Select Text and Language
  5. Click on Formats
  6. Under Numbers select Customize
  7. Change the Decimal separator from a comma (,) to a full stop (.)
  8. Then click on Ok/Save
  9. Test the Excel import again

For Mac OS version 10.8.3, please follow these instructions:

  1. Close the Excel application
  2. Click on the Apple button
  3. Select System Preferences
  4. Select Language and Text
  5. Click on Region
  6. Under Numbers select Customize
  7. Change the Decimal separator from a comma (,) to a full stop (.)
  8. Then click on Ok/Save
  9. Test the Excel import again

For Mac OS version 10.10.1, please follow these instructions:

  1. Close the Excel application
  2. Click on the Apple button
  3. Select System Preferences
  4. Select Language and Region
  5. Click Advanced
  6. Change the Decimal separator from a comma (,) to a full stop (.)
  7. Then click on Ok/Save
  8. Test the Excel import again

NB: If it does not work, try rebooting the machine, and test again.

 

This page was: Helpful | Not Helpful