BUG -- SUM after importing data

Hi,
I've been trying to find some info on this bug but so far nothing has worked.
I have copied a table from the web and am now trying to do so simple SUM 
functions. But it's not working.
I have tried to import the data after exporting them (in case HTML is an 
issue), but nothing.
I have tried some copy and paste special but didn't work.
So please help. I have Excel 2000 on XP. Email me at oliviermoratin@yahoo.com

Thanks again
0
Olivier (19)
10/27/2004 10:17:08 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
481 Views

Similar Articles

[PageSpeed] 25

Hi
try the following:
- copy an empty cell
- select your imported data
- goto 'edit - Paste Special' and choose 'Add'

"Olivier" wrote:

> Hi,
> I've been trying to find some info on this bug but so far nothing has worked.
> I have copied a table from the web and am now trying to do so simple SUM 
> functions. But it's not working.
> I have tried to import the data after exporting them (in case HTML is an 
> issue), but nothing.
> I have tried some copy and paste special but didn't work.
> So please help. I have Excel 2000 on XP. Email me at oliviermoratin@yahoo.com
> 
> Thanks again
0
frank.kabel (11126)
10/27/2004 11:01:01 AM
On Wed, 27 Oct 2004 03:17:08 -0700, "Olivier"
<Olivier@discussions.microsoft.com> wrote:

>Hi,
>I've been trying to find some info on this bug but so far nothing has worked.
>I have copied a table from the web and am now trying to do so simple SUM 
>functions. But it's not working.
>I have tried to import the data after exporting them (in case HTML is an 
>issue), but nothing.
>I have tried some copy and paste special but didn't work.
>So please help. I have Excel 2000 on XP. Email me at oliviermoratin@yahoo.com
>
>Thanks again

It is unlikely there is a bug in Excel causing this.  It is more likely that
what you think you are seeing in the imported data does not represent what is
truly there.

What does "not working" mean?

What result do you get?

One factor that occurs with HTML data is a terminal char(160) after your data.
This is an "invisible" character, but changes the way excel treats data.


--ron
0
ronrosenfeld (3122)
10/27/2004 11:31:00 AM
I have ran into "errors" like this where the numeric data was formatted as 
text. If that is the case, Excel will treat the numbers as text and not do 
numeric calculations on them.

Bill T. Ray
ray@nospam.engr.siu.edu



"Olivier" <Olivier@discussions.microsoft.com> wrote in message 
news:9DA30A4E-5585-4A6B-8161-C66A685A646D@microsoft.com...
> Hi,
> I've been trying to find some info on this bug but so far nothing has 
> worked.
> I have copied a table from the web and am now trying to do so simple SUM
> functions. But it's not working.
> I have tried to import the data after exporting them (in case HTML is an
> issue), but nothing.
> I have tried some copy and paste special but didn't work.
> So please help. I have Excel 2000 on XP. Email me at 
> oliviermoratin@yahoo.com
>
> Thanks again 


0
ray3780 (1)
10/27/2004 12:10:40 PM
Reply:

Similar Artilces:

Print Import Spec
I have created an import spec and saved it. Is there any way to print it? Using Access 2007. Thanks!! On Wed, 19 May 2010 06:54:01 -0700, Shairal <Shairal@discussions.microsoft.com> wrote: You could create a report on the MSysIMEX* tables. These are system tables so hidden by default, but you can reveal them from the Navigation Options dialog. -Tom. Microsoft Access MVP >I have created an import spec and saved it. Is there any way to print it? >Using Access 2007. >Thanks!! ...

how do I enable "import text file" excel 2002?
When importing text files into an Excel worksheet I previously went to "data" > "import external data" > "import text file" With Excel 2002 my choices lead me to a"select data source" window which is much more cumbersome. Does the "import text file" still exist in excel 2002? I pretty much use: file|open and copy that imported data to where I want it. But you can add an icon to your favorite toolbar to skip a step or two. tools|customize|commands tab|Data category look for "import data" and drag it to where you want. (n...

Data won't display under Employee link
Hey there, We have Business Portal setup running on our GP 8.0 environment. We have a link called Pay, under the employees header. When you click on the link you have option to choose and view all your paychecks. When we click that link all we get now is a black page. As far as I know nothing has changed. In the event logs I'm seeing a few informationtional items about the services account we use... User Manager VerifyUser -1 domain/user is not in teh UserWindowsIdentity table. I get that for a few users here and there, but the service account is the main account listed. Not ...

sum values in a column only for unhidden rows?
If I have a list of rows (some of which are hidden) is there a way t sum values in a column and IGNORE the values in the hidden rows - e.g only sum the values in that column for rows that are NOT hidden. Thx. lindas -- Message posted from http://www.ExcelForum.com Hi i use a "user defined function" - copy & paste this into a module sheet in your excel workbook (or personal.xls) Function sumvisible(r1 As Range) sumvisible = 0 On Error Resume Next For Each c In r1 If c.EntireRow.Hidden <> True Then sumvisible = sumvisible + c.Value ...

User entered data in XML
I'm writing data the user enters out to an XML file (using DataSet.WriteXML; DataSet is a typed DataSet created from an XML Schema). The problem I'm having is the user can (and needs to) enter characters like &, < and >. Is there some .NET function (maybe something in System.Xml) that will take a string and format it for output to an xml file (such as change all &'s to &amp;, etc.)? I'd hate to have to do String.Replace("&", "&amp;").Replace(...).Replace(...) all the fields manually, but if that's my only alternative... Ne...

BUG: CFrameWnd::OnDDEExecute MFC 7.1
This function is executed when a application file is double-clicked to open in a VC++ application. Specifically, this function is enabled by RegisterShellFileTypes () in the application's InitInstance. However, under MFC 7.1 for VC++ .NET 2003, CFrameWnd::OnDDEExecute has a bug that repeatedly generates this error message in the debugger Error: failed to execute DDE command ''. Therefore, the problem is that the command is not being propagated properly to this function, since the string should be something like '[open("C:\YourFileNameHere")]' rather...

trace order of data entry
I have 2 columns. in column A I will enter a name. in column b I will enter a number from 1 to 10. The names are not entered in the order 1 to 10 but randomly. Example I can enter number 5 then 2 then 9 then 1 and so on. How can I track the order in whick I names are entered. Can I do this on a different column rather than tracking changes. -- Radha Copy the code below and put it into the worksheet's code module. To do that, right-click on the worksheet's name tab and choose [View Code] from the popup list that appears. Then copy the code below and paste it into the module. ...

pst file import/export from 2003 to 2000
I use the import/export pst file function to keep my laptop and desktop outlook folders current. I have a new laptop with Outlook 2003 and my desktop has Outlook 2000. I can not import pst files from 2003 into 2000 and receive an error message. Is there a fix/workaround or file converter that will allow me to continue running both versions? Thanks No, but import/export was never a good solution to begin with. Use the old format PST in both installations. Copy and re-use PST's as needed to synchronize. -- Russ Valentine [MVP-Outlook] "Rick Michelson" <rickmichelson@...

Getting compile error on WorksheetFuntion.Sum line
I am trying to test if the sum of column 6 in a named range is 0 and if it is I hide the whole range, if its not I hide only teh lines that are 0 or blank. I get a complie error on the If WorksheetFuntion.Sum line. What is the correct syntax? Application.Goto reference:="MELLandLabor" Set rng = Range("MELLandLabor") If WorksheetFunction.Sum(rng.Cells(1, 6), rng.cells(rng.Rows.Count, 6) = 0 then Selection.EntireRow.Hidden = True Else For n = 1 To rng.Rows.Count rng.Cells(n, 6).Select If rng.Cells(n, 6) = &quo...

Sum from Table
Hello. I am creating a database to track a bank balance. I have a table called BankingMain, where I put all deposits in one column, and withdraws in another column. I have several forms where I would like to display the working balance in my account. The problem I am finding is that it will only let me sum the amounts on the page. I have several filters that apply depending upon my selections. Is there a way I can get a text box on the footer of my form to give me a running balance by summing all the withdraws and subtracting them from the sum of all deposits from my BankingMain table? ...

Applying formulas only to the subtotals of a data list
I have a large data list with subtotals (in fact with nested subtotals). I have collapsed the list so that only the subtotals are showing. Next I set up a few columns to the right of the data list with the intent of applying certain calculations, again ONLY to the subtotals. Here lieth the problem: when I set up the formulas for the first subtotal and attempt to simply drag it down, Excel obviously assumes that the copied formula applies to the next row of the full-blown, uncollapsed data list. Is there any way to accomplish the task without having to manually create a separate table ...

Graph where source data has different dates #2
I'm trying to do a comparision line graph with two series of data. The are both tracked by date with the same range (from April 2008 to April 2009). However one series has data monthly and the other has data weekly. When I try to combine on a graph the dates just don't line up. Is it possible to have these line up correctly. I've tried formatting the axis to days instead of months but it appears to only line up data points. So for the data reported monthly, it is graphed across the first 12 days. Hopefully that makes sense. If not, just let me know & I'll try t...

data update
i have created a form with combo boxes and command buttons that open forms for data insertion. the combo boxes get the data from the forms. when i close the forms, in order for the combos to show the new data i have to close the main form and reopen it. is there a way to avoid that? "angie" <angie@discussions.microsoft.com> wrote in message news:3371248F-CB54-4854-8D88-8B432C62BCB9@microsoft.com... >i have created a form with combo boxes and command buttons that open > forms for data insertion. the combo boxes ...

help with a cell displaying data...
If I have a cell with a basic formula =d3+d5, how do I get the cell to remain blank if one of the two referenced cells has no data? And does anyone have any tutorial links handy? Hi Matthew, Am Tue, 3 Aug 2010 09:12:14 -0400 schrieb Matthew: > If I have a cell with a basic formula =d3+d5, how do I get the cell to > remain blank if one of the two referenced cells has no data? =IF(COUNT(D3,D5)<2,"",D3+D5) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 "Claus Busch" <claus_busch@t-online.de> wrote ...

Log data entry time
Hi there I'd like to have Excel log the timestamp of each row of entered data. Example: Data Timestamp 4005401548638 24.01.2007 15:42 4005401548756 24.01.2007 15:43 (the first column, data, is entered using a handheld barcode scanner) How can I achieve this? Thanks -- Thomas Guignard Central Library Swiss Federal Institute of Technology, Lausanne I don't know if this'll work with a barcode scanner, but JE McGimpsey shows a way when entering data manually: http://www.mcgimpsey.com/excel/timestamp.html Thomas Guignard wrote: > > Hi there > > I'd like to ...

Any way besides cut/paste to combine data in many worksheets (sam.
Hi Craig Next time please in the body and not in the subject Try http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Craig" <Craig@discussions.microsoft.com> wrote in message news:F6902E54-4901-49A6-8DD4-EC2A8FF084D4@microsoft.com... > ...

Sorting data
Hi, My question here is.. how to sort a set of data in MS CRM system? For example, there is a set of data from "Case" that contain 3 types of category which are 'Problem', 'Request' and 'Question'. My question here,what should i do so that i can sorts the data those data? If it is query/filter data, that will be no problem, but this is about sorting the data. ...

Prove that important update from the M$ Corporation
--gycnacysdhgowi Content-Type: multipart/related; boundary="xhhkjmfijgvohg"; type="multipart/alternative" --xhhkjmfijgvohg Content-Type: multipart/alternative; boundary="znllmjipyv" --znllmjipyv Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Client this is the latest version of security update, the "January 1980, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the ...

How do I display data in a map
I want to link data in a spreadsheet to a map of the US. I am using Excel 2003. Is there any way to do this? i'm not sure of any specific places, but using Excel's External Data function, it shouldn't be too hard. what exactly are you looking for? -- medicenpringles ------------------------------------------------------------------------ medicenpringles's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16458 View this thread: http://www.excelforum.com/showthread.php?threadid=277880 I have resources in a table and I want to show allocation by...

using dataset writexml to update data and losing formatting
I have a Microsoft Access report (built on a SQL Server 2000 query) I have exported as xml/html. I include a stylesheet in the original export for formatting of the report. The schema is separate. When I preview this in my Visual web developer Express project it looks almost perfect (VBA generated color formatting is missing, but that's no show-stopper). So it works up to here. For unknown reasons I cannot use the Live Data option in the Access xml export (error says database object cannot be found when page is loaded) so I have created an asp.net page in VWD that uses a dataset ...

Convert One Column Data to Multiple Columns Data
I have a Query I am trying to Build that has the Following data: Name WO Days Old AD K-12345 10 AD K-12346 23 AD K-12368 02 AD K-12351 05 AD K-12386 20 What I am needing to is move the Days old Data to three Colums based off of the Days old Name WO 1-5 days 6-12 days 13+ Days AD K-12345 10 AD K-12346 23 AD K-12368 02 Something like that if it is possible. I have searched for this and could not find any other topics like...

Can I save "Data Text to columns" definitions
I have to convert text to columns and have to repeat the process every time the data changes. The file definitions are constant and wondered if there was any way that I could save the definitions and merely re-run the text to column function based on new data using an existing definition. EG 01000123000164 Use Data Text to columns to get 01 000123 000164 columns of data The column break is constant ie column 1 = positions 1&2, column 2 = positions 3-8 and column 3 = positions 9 -14. This I would like to save so I could just re-apply this definition to new data. At ...

Saving Data Into Columns ?
Hello: I have copied the following data from a web page that has it listed in three columns: 311.000 AM STRATCOM primary 321.000 AM STRATCOM secondary 243.000 AM Distress/guard However, as expected, if I just do a copy on these columns that I've highlighted, it wants to put them all in a single column in Excel. What I would like is to put the column data from the page I've copied into three separate columns in Excel. Then, to save it in .csv format. Any way of doing this, please ? Thanks, Bob Robert11 wrote: > Hello: > > I have copied th...

Running sum
How to do a running sum using Access? Depends ... how do you want to use it, and in which object? -- Ken Snell <MS ACCESS MVP> "tom" <Spamblocker@ameritech.net> wrote in message news:cYPPi.3390$wF3.2992@nlpi061.nbdc.sbc.com... > How to do a running sum using Access? > I figured out how to use it in a report. Pretty easy actually, How about in a query and a form? "Ken Snell (MVP)" <kthsneisllis9@ncoomcastt.renaetl> wrote in message news:OinMwoQDIHA.4880@TK2MSFTNGP03.phx.gbl... > Depends ... how do you want to use it, and ...

BUG? Windows 7/64bit and IE8/32bit
Hi, Just 2 short weeks ago I installed Windows7 64bit on my nice and shiny new NB and already my nerves are on edge because of IE8's weird behaviour. Since IE8/64 does not support Flash I was forced to switch to IE8/32 and that's when the trouble started. It does not seem possible to open any new window or tab from the context menu. i.e. right-clicking on a link and choose "open link in new tab". A new tab is created alright, but it hangs and hangs and hangs and never shows any content. I either have to click a link directly - which works but will "lose&qu...