Re: Sum not working

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 14:13:00 -0700

When you imported the values in they were imported as Text.

Copy an empty cell, select your "numbers" and choose Edit/Paste Special,
selecting the Values and Add radio buttons. Click OK.

In article <5a9501c40099$c829dec0$a401280a@phx.gbl>,
 "dawn" <anonymous@discussions.microsoft.com> wrote:

> I have done this in many other worksheets and it works
> fine. I first import the data in as General format.
> Then I use the IF function to find a quantity for each po
> number and put on a printout. Normally then I just use
> the Sum function to give me a total of quantities for
> each po number. There is nothing no different about
> these formulas but the sum is giving me a zero. If i go
> in the quantity field and retype the number in (which I
> don't want to do, this is why this is self-calculating)
> then it gives the correct sum. I checked under error-
> checking to see if the number is a text and it is not but
> if I do an IStext it says true. If i convert to number
> even though the error checker says it is not it still
> gives me a zero!!!!! Everything is the same and i have
> done this many times!!! Why is this not working!!! I
> need this to total itself or there is no use for Excel.
> This is pissing me off cause I need this now not
> tomorrow!!