Answers.Body: <p>My workaround for this is to immediately convert the CSV file in a text editor such as Notepad++ or UltraEdit. </p>
  
  <p>As soon as it's downloaded I open the CSV as UTF8, then immediately save it as ANSI. It's a bit fiddly, but fixes the £ problem, as well as any unusual characters in names/addresses.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-11T11:29:35.903Z
Answers.LastActivityDate: 2016-01-11T11:29:35.903Z
Answers.UserDisplayName: Andrew West
Answers.Body: <p>When you look at the csv, what software do you use? Are you looking with Excel, and if so is Excel also expecting UTF8?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-11T09:20:22.130Z
Answers.Text: yes, I am using Excel 2013. I didn't understand, what do you mean by " is Excel also expecting UTF8?"
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-11T11:01:15.140Z
Answers.Text: Excel also uses encoding to show you the csv file. If Excel is set to a different encoding you will get strange characters. See http://help.surveygizmo.com/help/article/link/encode-an-excel-file-to-utf-8-or-utf-16
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-11T08:18:02.300Z
Answers.LastActivityDate: 2016-01-11T08:18:02.300Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Whenever I export a csv from any report, if it contains a £ sign, there is always Â appears before. How to resolve it please? I am using civicrm 4.6.11, my mysql database characterset is set to "UTF8".</p>
  
Tags: <civicontribute><currency>
Title: How to resolve issue with " Â " appears before currency sign?
ThreadText: # How to resolve issue with " Â " appears before currency sign?
  
  (Asked by: username_0 on 2016-01-10)
  
  Whenever I export a csv from any report, if it contains a £ sign, there is always Â appears before. How to resolve it please? I am using civicrm 4.6.11, my mysql database characterset is set to "UTF8".
  
  **Tags:** civicontribute, currency
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-01-11. Score: 2
  
  My workaround for this is to immediately convert the CSV file in a text editor such as Notepad++ or UltraEdit.
  
  As soon as it's downloaded I open the CSV as UTF8, then immediately save it as ANSI. It's a bit fiddly, but fixes the £ problem, as well as any unusual characters in names/addresses.
  
  
  ---
  
  ### Answer by username_2 on 2016-01-11. Score: 1
  
  When you look at the csv, what software do you use? Are you looking with Excel, and if so is Excel also expecting UTF8?
  
  > **Comments:**
  > **username_0**: yes, I am using Excel 2013. I didn't understand, what do you mean by " is Excel also expecting UTF8?"  
  > **username_2**: Excel also uses encoding to show you the csv file. If Excel is set to a different encoding you will get strange characters. See http://help.surveygizmo.com/help/article/link/encode-an-excel-file-to-utf-8-or-utf-16  
  
  ---
  
  