I've just exported the earnings report for September as a csv document - and then opened it in Excel and am absolutely dismayed to find that all the income reported is formatted as TEXT!
Bottom Line: this means it is completely useless for manipulation when imported into Excel because the $ are not numbers - they have had an $ artificially inserted as a prefix in front of the number which nullifies the value of this data as numerical data.
Could you PLEASE:
* put the denomination for the value at the top of the column (i.e. incorporate $ in all relevant column headings NOT as prefix)
* RENDER ALL EARNINGS AS NUMERICAL VALUES and not text (i.e. remove the $ which currently prefaces all numbers)
This would then allow calculations (e.g. averages, percentages etc) with ease when the data is exported to a spreadsheet
Thank you for your consideration.
A csv file is just a text file. When you import it to Excel you can choose to import that part as numbers. Or, you can select the column and change the format to numbers.
To remove the $ just do a search/replace. Yes this bit is annoying, I can see that.
which is why it is a lot simpler if the TEXT that is entered is just numbers.......
One person at the HQ end enters as numbers as opposed to all hubbers who download into excel having to convert the text to numbers - assuming they know how to do this.
It's just an awful lot simpler to make it simple in the first place by making numbers just numbers and include a $ sign as a column heading
I upload HP's CSVs into Google Spreadsheets (now in Google Drive) and it always treats numerical entries as numbers automatically without me having to do anything. In GS you can averages, sorting, etc, so some people might prefer to use it instead of Excel.
GS also has the option of letting you download the sheets as .xlsx files, which perhaps you prefer to work with, and it preserves the number formatting you need.
but it's not a numerical entry - it's text!
I prefer to download csvs direct to Excel which is what I've been doing for the last eight years with Squidoo.
I then change them to Excel files (because I've used Excel for some 20 odd years)
However I haven't had the problem before of being unable to manipulate numerical data because it's been represented as text rather than as numbers
For the record, csv files are comma separated files. They are capable of recording both numerical and text data in plain format and it's very easy to import them into Excel so long as text is text and numbers are numbers.
I can't think of a good reason why numbers of dollars should not be represented as numbers in a csv file - given they will have started life as numbers!
That file format is text, and can only be text, although excel can sometimes figure out it is meant to be a number. Just select the columns in the excel spreadsheet -- go to cell format -- select numeral. That leads it to disregard the dollar sign. If they remove it someone will be here asking what units it in.
You think so? Even if they put a $dollar sign at the top of each column?
You don't think the calibre of person who writes hubs can cope with $ signs at the top of columns - which is a perfectly normal and routine way of representing cash?
How difficult is it to input numbers only?
Re the file format issue csv can be text or numbers - it is NOT a file format which ONLY deals in text. I also guarantee that these numbers started life as numbers!
by Katherine Tyrrell 4 years ago
I'm wondering if the HubPages Team are aware that earnings data on Amazon sales exported to a csv file is much less useful than it could be because the $ notation is a prefix to each amount rather than topping the column.That means it's impossible to sum the data using a formula.In other words the...
by Hestia DeVoto 7 years ago
Can the ad program earnings report for all program be updated so that it shows one column with the AdSense earnings and a second column of the eBay earnings and then a daily total? That would make it really useful and then I could get the breakdowns just by running a single report.
by Anna 7 years ago
How do you change numbers in Excel from text to number format?
by Juliette Kando FI Chor 6 years ago
I recently filled in a survey on how to improve HubPages but forgot to mention a very important design issue which has been bothering me for a long time.When a text capsule is very long, I like to turn it into 2 adjacent capsules so it works like 2 columns. Easier to read, right? But every time I...
by Petite Hubpages Fanatic 6 years ago
Why are my hubpages earnings as low as a dollar per month?I have 14 hubs. All of them are featured and all these together earn just around 1 dollar. Is something wrong with my hubs?
by Person of Interest 12 months ago
Anyone know of a single-column theme selection that still works? Help!
Copyright © 2019 HubPages Inc. and respective owners. Other product and company names shown may be trademarks of their respective owners. HubPages® is a registered Service Mark of HubPages, Inc. HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.
HubPages Inc, a part of Maven Inc.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|