Fixing accents errors in excel

Copper Contributor

I need to download some text data in Portuguese which comes with accents (e.g. ã, í, é, ...). The website gives me the option to download the file either in excel or pdf. Although I want the data in excel, it reads the accents with error whereas pdf doesn't (the files are attached). Would anyone know how to fix such errors in excel?
Many thanks
Paula

3 Replies

@PaulaSpinola 

Hi Paula

  1. Click on the File Tab >> Click Options (or use the Shortcut ALT F T)
  2. Click on Language
  3. Click on the Drop list for selecting a language
  4. Select Portuguese

language.png

 

Hope that Helps

Nabil Mourad

@nabilmourad 

Thanks! However, I already have Portuguese as one of the languages. I think the problem was generated in the system where the file was generated. I guess this means there is no way to recover the original accents (or likewise recover the data without any accents or errors coming from them)?

 

clipboard_image_0.png

@PaulaSpinola 

Unfortunately Paula, that could be a possibility !!
I'm using multiple languages on my laptop and all what I do is to add the language as I sowed earlier and select the language from the Language settings in the Windows Settings (or from the right side of the Task Bar)
Hope I could help more.

Nabil Mourad