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 3 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 Anna 6 years ago
How do you change numbers in Excel from text to number format?
by Person of Interest 5 weeks ago
Anyone know of a single-column theme selection that still works? Help!
by Juliette Kando FI Chor 5 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 Mikeydoes 7 years ago
Well I decided to make a simple little layout to hopefully help some people out.It is clear videos are the future, and the lack of videos on this site is actually kind of embarrassing. Content is key and we should be using every available resource that we have here.My Hubs all certainly can be...
by GlenR 5 weeks ago
I’m wondering why recently it sometimes takes several days for earnings reports to update. Any Thoughts?
Copyright © 2018 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 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.|