homepage Welcome to WebmasterWorld Guest from 54.196.63.93
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Google / Google AdWords
Forum Library, Charter, Moderators: buckworks & eWhisper & skibum

Google AdWords Forum

    
Problem with Adwords Reports in Excel
#VALUE! Errors When Trying to Use Cells
bigdealioo

5+ Year Member



 
Msg#: 3714538 posted 4:22 am on Aug 4, 2008 (gmt 0)

I save the report in ".csv for Excel". Then in Excel I save the .csv as .xls. Then in XLS I try to work with cells that contain numbers - for example, use the value of some CPC in a formula - and I inevitably get #VALUE! errors. It seems that the numbers are not actually in the numbers format (maybe text)? And that $ values are not actually in Currency format?

This is extremely frustrating. What's the quickest way to fix this on my end?

THANKS.

 

smallcompany

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3714538 posted 5:06 am on Aug 4, 2008 (gmt 0)

I'm not any Excel guy, but I did have problems with using arrays in Excel. If you are using them in your formulas, there is a special command when you apply them (“something” + Enter).
Other than that, try with formatting cells before you use the numbers.
Also, try copying data from original CSV and pasting it as “values only” into a new file, and then saving as Excel file version.
I always had a problem with CSVs from some banks (credit cards). Dates would always get messed up and I would have to use some of the upper methods to get them right.

bigdealioo

5+ Year Member



 
Msg#: 3714538 posted 5:50 am on Aug 4, 2008 (gmt 0)

I tried changing the format of the dollar values to Currency and it didnt help. Still got the #VALUE! error.

smallcompany

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3714538 posted 6:16 am on Aug 4, 2008 (gmt 0)

Have you tested it with creating a new Excel file and manually entering numbers? Do a simulation. If you get it to work, that will prove your formula is working. If not, don’t bother about Google's CSV, fix the formula.

bigdealioo

5+ Year Member



 
Msg#: 3714538 posted 6:51 am on Aug 4, 2008 (gmt 0)

By formula I mean ANY calculation .. like A2+1 for example, even that doesnt work.

netmeg

WebmasterWorld Senior Member netmeg us a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



 
Msg#: 3714538 posted 2:26 pm on Aug 4, 2008 (gmt 0)

Hunh; what report are you running? I just looked at a couple of mine - the cells are formatted, and calculations work just fine.

bigdealioo

5+ Year Member



 
Msg#: 3714538 posted 2:32 am on Aug 6, 2008 (gmt 0)

so noone has the same problem, eh?

onlineleben

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 3714538 posted 6:50 am on Aug 6, 2008 (gmt 0)

the numbers are not actually in the numbers format

It sounds silly, but when only a few lines were involved I solved it by retyping the values.

The better way is this:
I inserted a new colum right of the one with the wrongly formatted values, then entered =VALUE(C5) (where C5 is the cell to the left) in the first line and copied the formula down to the end. The new column now contains numeric values of the column to the left.
Mark all of these new cells and click on "Copy", then click on the edit menu and do a "Paste Special - Values"

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Google / Google AdWords
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved