excel not recognising adwords report format
I've downloaded my first search terms report and noticed that in two columns I have data which I cannot Sort. The Date cannot be formatted or sorted as well as the Cost and average CPC.
DAte is currently in this format and cost is shown with another character infront of it.
|Sep 6, 2016|
and cost is in this format
Re: excel not recognising adwords report format
This isn't a lot of information but I will do my best to help based on what I know.
Date: If I input "Sep 6, 2016" as text into cell A1 then I can turn it into a standard (and sortable date) by using this formula in an adjacent cell =TEXT(A1,"mm/dd/yy")
Cost: There are a couple potential solutions for this:
- Delete the currency from all numbers by doing a find and replace (ctrl+h). Find "â‚¬" and replace with "".
- In an adjacent cell, try dividing the value of the cost by 1. This sometimes works by forcing excel to treat the value like a number.
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.