Format of downloaded data

> A data provider enables me to download real estate data that includes a 
column of sale prices in dollar amounts.
> 
> The search through Internet explorer shows a page of data which can then be
> downloaded to Excel.  However the dollar items come into Excel as labels
> rather than numbers which then prevents me from manipulating this data.
> 
> This only happens when I download the data with my office desktop  computer.
>  When I download it at home or on my laptop the data comes through as numbers
> not labels.  This suggests that I have a setting which is incorrect on my
> office desktop computer probably in IE.
> 
> Does anybody have any thoughts?
> 
> Mikie


0
8/21/2007 1:48:02 AM
excel 39879 articles. 2 followers. Follow

1 Replies
642 Views

Similar Articles

[PageSpeed] 32

After importing do the imported cells show Text under menu format/cells?

I don't know how it happened but you can at least deal with it if you
don't figure it out. I'll address that, though hopefully someone else
who's done a lot of web-grabs will recognize your plight and explain
just why it happened.

Are there extraneous characters on the labels, such as a trailing minus
sign?  If not, then they may look like "labels" (text) but you can still
do your math on them.  Sometimes Excel "imports as text" and the usual
remedy is to click a blank cell, copy it, select the imported values,
and Paste Special, clicking on the "Add" check box.  This would "add
zero" to each of the selected cells, ridding the text aspect.

The Text format can have another nasty effect that may be what you're
running into.  If the cell you do the manipulation in ("the formula
cell") is text format (check menu format/cells/number), then if you type
=a1*1.1, then that's all you get - no multiplication or math is done at
all.  You need to format the formula cell as General or Number before
entering the formula in that situation. (Or fix them after the fact by
replacing = with = .)

Finally, if there are those extraneous characters, they can be stripped
off using worksheet functions like LEFT, MID and LEN. Fortunately these
are not necessary to handle commas.  If cell A1 shows 175,000, you can
still go =a1*1.1 (again, enter the formula in a nontext cell). (However
keep in mind that there may be invisible characters picked up from a web
page, often at the beginning or end of the range.)

Obviously you'd like to avoid all of that and just get it as numeric in
the first place. My guess there would be that you're not selecting
exactly the same data to copy/paste. See if your situation persists if
you select EXACTLY the same thing. My recollection is that with some
data transfers that Microsoft looks at the first value copied and
decides text vs. numeric from that - but I'm not certain if or when that
occurs.  Maybe you're copying text headings in one situation but not the
other?

On Mon, 20 Aug 2007 18:48:02 -0700, MikieSlats
<MikieSlats@discussions.microsoft.com> wrote:

>> A data provider enables me to download real estate data that includes a 
>> column of sale prices in dollar amounts.
>> 
>> The search through Internet explorer shows a page of data which can then be
>> downloaded to Excel.  However the dollar items come into Excel as labels
>> rather than numbers which then prevents me from manipulating this data.
>> 
>> This only happens when I download the data with my office desktop  computer.
>>  When I download it at home or on my laptop the data comes through as numbers
>> not labels.  This suggests that I have a setting which is incorrect on my
>> office desktop computer probably in IE.
>> 
>> Does anybody have any thoughts?
>> 
>> Mikie
0
8/21/2007 5:47:29 AM
Reply:

Similar Artilces:

Input data check
Hi I want to check 10 fields to confirm they have data entered into them. Before I print a document. Field1 Not is null Field2 Not Isnull And so on. If any of the fields are blank I want a msgbox to appear listing the field names which have no data. I do not want to set the field to, data required, because there may be a reason why we have been unable to enter the required data. How do I set this up? Thanks Bob Bob, Something like... Use check boxes, combo boxes, text boxes, etc... If IsNull(Me!CheckBox1) Then Msg...

Publisher catelog merge- cannot open data source file
whether I try to open the source file or open a new one, I get the message: operation cannot be completed becasue of dialog or database engine failures. Please try again later. Troubleshooting advice suggestd to undate the engine from Windows update - can't find it. Does anyone have more specific troubleshooting advice? This article has a solution: You receive a "The operation cannot be completed because of dialog or data base engine failures" error message when you try to perform a mail merge by using an Outlook 2003 contact folder in Publisher 2003 http://support.mic...

Excluding data points in a chart
Is there some way to specify conditions under which data points should be excluded in a chart? In particular, I have two columns for which I want to create a scatter plot. However, some of the rows are missing data for one or the other column. Is there a simple way to tell Excel to ignore such rows? Jim Hi Jim, 1) With the chart selected, use Tools|Options and open the Chart tab; specify what is to happen with missing values OR 2) Where data is missing enter =NA() -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "JM" <anonymous@discussions....

Suppressing auto format in Excel
I have a .CSV file that is automatically generated by a program. Apparently, when the file is opened with Excel, the numeric fields that are enclosed in double quotes in the file and look like "123,456.1234" are being formatted by Excel and displayed with only 2 decimals. The cause of the problem seems to be the comma in the number, which I don't really want to remove. Is there any way to suppress automatic cell formatting in Excel, so the contents could be displayed just the way it appears in the source file? In the Text import wizard - step 3 of 3 - select the offending colu...

Pivot Table Cell Formatting
A pivot table "seems" to want to define all the cells within the table as numbers. Several columns of data within my source data are character (i.e. Y/N). The pivot table displays all Y and N's as a 1 when the cell is defined as a count. If you change to a sum or any other "available" types, they display as 0's. I can't seem to get around this. I want the Y or N value displayed. Any ideas or suggestions. Thanks, Jim G. Hi Jim the data section of a pivot table can (AFAIK) only consist of (aggregated) values. That is counts, sums, averages, etc. You're not ...

Comma delimited data conversion to XML
Is there an easy way to convert a string of data to XML format without having to create the xml one field at a time? Sorry I'm a newbie and my xml knowledge is limited. I have tried to search through the documentation in .net but nothing jumps out at me. Sample code would be great! "Larry Williams" <Larry Williams@discussions.microsoft.com> wrote in message news:AC7696F6-EFA4-4C29-8290-F1A4211CC88C@microsoft.com... > Is there an easy way to convert a string of data to XML format without having > to create the xml one field at a time? Certainly, but the easier ...

data space
i found that strange. i checked properties in admin. and found this under general- size- 202 mb space available 0.00 mb usage 100% my data base size should be 2 gig. my space available is saying 0mb yet the program is not shuting down. it continues to save journals and sales data. Can anyone help because that is starnge to me or am i reading something wrong. i am running ver. 1.3. what is also strange to me is that the size of the data base is decreasing. Can someone help. This is a multi-part message in MIME format. ------=_Nex...

PDF File Download
I want to offer on my website free downloadable documents that are in PDF format. What is the best way to set up a "Click Here" and the file is downloaded automatically in FP? Thank you and Merry Christmas! Tom Tom wrote: > I want to offer on my website free downloadable documents > that are in PDF format. > > What is the best way to set up a "Click Here" and the > file is downloaded automatically in FP? > > Thank you and Merry Christmas! > > Tom I fail to see what this has to do with Publisher - especially if you're using FrontPage. ...

Excel using =RC[-1] format and I don't want it
On this machine only, Excel will use the format =RC[-1] when I am entering a formula on the command line by hand and click on a cell to reference it in the formula. I don't know how this got on but I would like it to go off. On my other machines, it does the old familiar A1:B2 style of cell reference. I can't even search for how to fix it since I can't determine what this is called so I can turn it off. The only reference I have seen is a button that is only effective for macro creating and I am not creating a macro, just a formula, interactively, in the cell. How ...

Problems downloading transactions from TD Ameritrade
I am getting ETF transaction downloads fine from TD Ameritrade, but not mutual fund transactions. I get the account balance update saying that, of course, my Money Plus Deluxe balance doesn't match that of the brokerage (because it didn't get the transactions.) I thought the problem might be that I was running Money 2006, so I updated to the 2008 Money Plus Deluxe but the problem remains. TD Ameritrade tech support just shrugs their shoulders. Has anyone else had this problem with TD Ameritrade? with any other broker? What was the solution? I've tried a lot the suggestio...

Data file did not close properly #2
I have read all kinds of solutions to this error. Has any thing difinitive been offered that solves the problem. Appreciated Jerry There isnt a difinative solution as the problem can be caused by a number of differing things "Jerry" <jerry@home.home> wrote in message news:eRfw6Cs1IHA.5300@TK2MSFTNGP06.phx.gbl... >I have read all kinds of solutions to this error. Has any thing difinitive >been offered that solves the problem. Appreciated > > Jerry > "Jerry" <jerry@home.home> wrote in message news:eRfw6Cs1IHA.5300@TK2MSFTNGP06.phx.gbl...

Add multiple new records based on quantity duplicating data
I am creating a simple form to allow a new user to list a part number and requested quantity. Upon executing a submit button, I would need the part number value added/duplicated into an existing table as many times as the requested quantity. However, the requested quantity can not exceed 999. Simplest solution if you are familiar with code would be to OpenRecordset, and AddNew in a loop. An alternative would be to create a table containing 999 records, and use it as the source table for an Append query statement, with criteria limiting it to the desired number. This link explains how t...

Data tables ? Circular references ?
Hi, If I setup a data table as follows: A1=0 A2=0 A3=A1+A2 Then in B3 place the formulae A3+1 and copy it along to K3 And in A4 place the formulae A3+1 and copy it down to A13 Finishing off by selecting the range A3:K13 and choosing Data->Table, Row input cell = A1, Column Input cell = A2 The results in the intersection start from 2 and end at 1.7E+11 Now if I Edit->Copy, PasteValues the formulae in cells B3:K3, and likewise value the formulae in A4:A13 the results change twice over, once for each Copy-PasteValues sequence. What's going on ? Regards Steve Think the ...

Data showing up in Cells as ####
I'm trying to enter an amount in a Column labeled "Limit"...I've tried changing the cell's format but no matter what I do, the data shows up as ####. How can I change this to reflect the actual numbers? -- MCD Increase the column width >-----Original Message----- >I'm trying to enter an amount in a Column labeled "Limit"...I've tried changing the cell's format but no matter what I do, the data shows up as ####. How can I change this to reflect the actual numbers? >-- >MCD >. > Or reduce the Font size?? anonymous@discussi...

Conditional Format: Dates
Date is displayed in cell like this: Thursday, January 01, 2004 Currently, cells have no cell color format. How can I set formatting so cells containing 'Sunday' are a different color? Is there a formula I can use or some function that will do this for me? If the dates are text use =ISNUMBER(SEARCH("Sunday",A1)) in the formula is box, if they are real dates use =WEEKDAY(A1,2)=7 format>conditional formatting and formula is -- Regards, Peo Sjoblom "JEM" <abc@def.com> wrote in message news:emRrHL1IEHA.2688@tk2msftngp13.phx.gbl... &g...

data source for chart
I have spreadsheets with a lot of data in them. I have multiple columns. The two columns I need to compare right now have initials in one column and dates in another column. The initials are nurses and the date column is a denial date. I need to create a chart that will show a possible trend of certain nursing staff having a higher number of denials. I know I highlight those two columns, but I think I have to change the date data to something that can be counted??? Please advise. I am desperate. and there are more of these kind of charts to come that I will have to do. Thank yo...

free download
I downloaded IE8 which is supposed to be free. It wil not work. It wants me to choose a plan that costs money. Why is this happening? If I uninstall will it get rid of it & put me back to the MSN version I have always used? Or is there a way to get passed the "plan" prompt. Again It's supposed to be free. No-charge support for Internet Explorer 8 installation, set-up and usage (only) is available via the phone based on your locale through 31 December 2009. Customers must be running Windows XP or Windows Vista in a non-domain environment. => US & CA Res...

downloading from outlook 2002 to outlook 2000
Hi, This happened to me twice already. I installes Office XP on both occasions and later on uninstalled it and installed Office 2000 due to netfolders feature. But in both occasion Outlook 2000 can no longer auto resolve names when using Cntrl-K. If you remove the profile too, you can no longer add any mailbox since it refuses to lookup the Exchange Server Directory. Has anybody encountered this issue already. I had to reformat the notebooks for both occasion to solve the problem. BTW, we are using Exchange SErver 5.5 as our Mail server. Thanks, Joko i mean downgrading... "J...

Preventing auto-formatting when Replacing
Say I have a cell that contains LED2/14 The cell is formatted as Text. If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this infuriating behavior? Thanks, Frank How about: Edit|Replace LED with ' (apostrophe) Frank Marousek wrote: > > Say I have a cell that contains > > LED2/14 > > The cell is formatted as Text. > > If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting > the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to...

please post a 2006 calendar iin excel format. thank you.
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=21daf53e-db8a-443e-a122-d0e35c3e84aa&dg=microsoft.public.excel.misc Try File > New and look at the templates available. In particular http://offic...

Finding Unique Data
I have 3 coumns in a table. all 3 columns have duplicate data. But I want to find unique data in column A only. How do i do this in ACESS 2007 ? Please help. hi Rumy, On 02.02.2010 15:40, Rumy wrote: > I have 3 coumns in a table. all 3 columns have duplicate data. But I want to > find unique data in column A only. How do i do this in ACESS 2007 ? Please > help. Maybe so: SELECT * FROM yourTable WHERE (A <> B) AND (A <> C) mfG --> stefan <-- Under query types, you have one for Find Umatched Data. That will tell you which data is unique. --...

Getting the High and Low Tides from a Series of Data
Hello, I have a long list of data for tide levels which is like as follows: Date/Time Tide Level Now, I want to extract from this long series of data all the high tides and low tides, which in mathematical terms is to extract all the local maximums and local minimums, together with the associated Date/Time from the data. I have another programme that generates this series of data basing on a set of parameters, but I don't know what the function is, so I can't really find the 1st order derivative and set it to zero to get all the roots, etc. How should I go about doing this? Us...

Formatting Cells Question
Hi I am having troubles with formatting cells in EXCEL 2003. I have a column of many hundreds of rows lthat contain data like this: 01Jan12 on fist glance this looks like a date but it really is not. EXCEL on the other automatically assumes it is a date and formats as such. 2001-Jan-12 I have tried formatting as text, General and even experimented with custom formats to no avail. In the same column I have 03Mar1543 Which is dispolayed exactly as is. How can I get EXCEL to simply display data like 01Jan12 exactly as is? You must format the cell as Text BEFORE typing any information...

Chart formatting #3
Is there a way to shade certain areas of a line graph? I have a simple line graph extending horizontally from point 1 to 10 on the x-axis. I would like to shade the entire background area of the graph from points 2-4 and points 6-8. Is there a way to make the graph apear that the background is grayed out between these points. Thanks Chris Chris - This has been sitting here a long time... Make a combo chart. Start by locking the Y axis scale parameters (uncheck the auto boxes). Add a series to your chart which has zero values where you want no shading and <Y axis max> where ...

Insert Data Generate Date into an SSRS Report Header
I generate SSIS package multiple table data loads, and write a record to a data generation table. I wish to insert the last data generation date from a SQL Server into the header (or footer) of an SSRS report. Does anyone have thoughts on best practice for this ? Thank you, Issue SELECT TOP 1 datecolumn FROM tbl ORDER BY datecolumn DESC "jm27102" <jm27102@discussions.microsoft.com> wrote in message news:29B2B300-655E-42D7-B397-DEEB5FE2525D@microsoft.com... >I generate SSIS package multiple table data loads, and write a record to a > data generation ta...