Re: Subtraction

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Another reply to my own post. I just tried to copy/paste baseball stats from
Fox Sports again pasting as HTML and all formulas worked perfectly. It
appears that something is interferring from Yahoo.... I guess I'll use Fox
but if you can figure out what the problem is with Yahoo stats, I'd be real
interested in knowing. Thanks again.

"Rookie" wrote:

I have copy/pasted stats from Yahoo baseball stats. I am trying to average 2
years of specific stats (ie: 2006 HR and 2007 HR for a single player). This
is where I get #DIV/0! if I try to do it with the numbers that were
copy/pasted from the internet (Using IMSUB to subtract I get the error #NUM!
and if I use SUM to add I just get a Zero). If I manually enter these same
numbers in any blank cells anywhere else on the same worksheet the formula
works fine. I just can't do it with the numbers that I copy/pasted from the
internet even if I recopy/paste them to a different cell. I have tried to
'paste special' from the internet and have 3 options: HTML, Unicode Text, or
Text. I have to use HTML or they don't format correctly into columns. Since
I can use the formulas with numbers I enter myself I tend to believe it's the
way the data is entered into the worksheet not the program itself. I feel
there is something wrong with the copy/paste or something else is getting
pasted that I'm not aware of and is interfering with the execution of the
formulas. Like I said, I've tried SUM, IMSUB, and AVERAGE and they don't work
with the numbers pasted from the internet. I haven't tried any other
forumulas. Those are primarily the ones I would use. Thanks for you help.

"Niek Otten" wrote:

<the formulas didn't work. I also cannot add these numbers>.

What does that mean? What *exactly* do you do and what do you see happening?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Rookie" <Rookie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8E68EE44-4770-4A4B-B983-7C91D6EE457A@xxxxxxxxxxxxxxxx
| It was already checked automatic.
|
| "Niek Otten" wrote:
|
| > Try Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > "Rookie" <Rookie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AB417DB5-F66C-49F6-903A-E42E304D840F@xxxxxxxxxxxxxxxx
| > | It still didn't work. I was able to change the numbers but the formulas
| > | didn't work. I
| > | also cannot add these numbers.
| > | "Niek Otten" wrote:
| > |
| > | > Format an empty cell as General. Put the number 1 in it. Edit>Copy. Select your cells with the "numbers". Edit>Paste
Special,
| > | > check Multiply.
| > | > Now the cells are real numbers. That is, if they don't contain spaces or other invisible characters.
| > | > Post back if they do; that can be remedied too.
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > "Rookie" <Rookie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B2B94C5D-5D61-46DA-8D03-48668E2A21B9@xxxxxxxxxxxxxxxx
| > | > | In reply to my own post, I have found that I can use the AVERAGE formula and
| > | > | IMSUB on a blank worksheet that I input the numbers manually. However, if I
| > | > | copy/paste data into a worksheet I can no longer use those functions.
| > | > | However, I can use ADD. I have checked the format of the cells and it
| > | > | doesn't seem to matter if I have them formated as "general" or "number."
| > | > | There's way too much data to input everything manually and that would defeat
| > | > | the purpose of having excel. Can anyone help me overcome this obstacle?
| > | > | Thanks.
| > | > |
| > | > | "Rookie" wrote:
| > | > |
| > | > | > I have been trying to subtract 2 simple numbers. I can do it by entering the
| > | > | > formula =123-111 but would to make a formula where I could use the cell as a
| > | > | > reference (ie H2-H3)
| > | > | >
| > | > | > I have also been trying to find the average of 2 numbers. I use
| > | > | > =AVERAGE(H2,H3)
| > | > | > I get #DIV/0! I can't seem to get it to divide by 2.
| > | >
| > | >
| > | >
| >
| >
| >



.

Relevant Pages

  • Re: Translate HTML table to Word table?
    ... Copy/Paste is limited only by your machinešs available disk space and your ... chugging well above that on the Mac file system or on Windows XP. ... Yahoo email was a full and complete ... >> After the initial headers and a plain text part, you'll find an HTML part. ...
    (microsoft.public.mac.office.word)
  • Re: article 319032 is no good
    ... including Google Groups ... >>Copy/paste the following line into an IE Addressbar, ... >>Also state your Windows version. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: HTML not interpretted
    ... Did you put it in Code View (aka: ... Copy/Paste into Code View/HTML. ... Insert | Web Components |Advanced Controls | HTML ... Then File | Preview In Browser if you wanna see it in a browser ...
    (microsoft.public.frontpage.client)
  • Re: OLE_LINK & MS Word 2003
    ... And they're generally created when I copy/paste, say, table data into an MS ... > Internet or anything. ... I am just copying and pasting internally to the ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.newusers)
  • Re: Subtraction
    ... I have copy/pasted stats from Yahoo baseball stats. ... internet even if I recopy/paste them to a different cell. ... there is something wrong with the copy/paste or something else is getting ... Microsoft MVP - Excel ...
    (microsoft.public.excel.worksheet.functions)