Prev: Text data -- linking Excel sheets
Next: Can I title columns with out them having a row number?
From: Martin on 4 Feb 2010 13:17
This is very strange...Excel does not calculate any formula. I can do a
simple =A1+A2, and it just return a zero value.

I made sure of the following:
- Cell is set to General (tried it with different cell settings too)
- Autocalc is on in settings (even a manual F9 calc doesn't work)

--
Martin Verville
From: "David Biddulph" groups [at] on 4 Feb 2010 13:29
We might need a few more clues:
What is in A1? What is in A2?
--
David Biddulph

"Martin" <Martin(a)discussions.microsoft.com> wrote in message
news:A9A25385-5BE8-4D38-A7A7-15E523C69DD9(a)microsoft.com...
> This is very strange...Excel does not calculate any formula. I can do a
> simple =A1+A2, and it just return a zero value.
>
> I made sure of the following:
> - Cell is set to General (tried it with different cell settings too)
> - Autocalc is on in settings (even a manual F9 calc doesn't work)
>
> --
> Martin Verville


From: Martin on 4 Feb 2010 14:22
Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero
onstead of tree.

I've tried with a couple different excel file in the company and i'm at the
same point, always the same problem.

--
Martin Verville


"David Biddulph" wrote:

> We might need a few more clues:
> What is in A1? What is in A2?
> --
> David Biddulph
>
> "Martin" <Martin(a)discussions.microsoft.com> wrote in message
> news:A9A25385-5BE8-4D38-A7A7-15E523C69DD9(a)microsoft.com...
> > This is very strange...Excel does not calculate any formula. I can do a
> > simple =A1+A2, and it just return a zero value.
> >
> > I made sure of the following:
> > - Cell is set to General (tried it with different cell settings too)
> > - Autocalc is on in settings (even a manual F9 calc doesn't work)
> >
> > --
> > Martin Verville
>
>
> .
>
From: Gord Dibben on 4 Feb 2010 15:12
Sounds like your numbers are Text.

Format to General or Number then copy an empty cell.

Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

On Thu, 4 Feb 2010 11:22:01 -0800, Martin <Martin(a)discussions.microsoft.com>
wrote:

>Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero
>onstead of tree.
>
>I've tried with a couple different excel file in the company and i'm at the
>same point, always the same problem.

From: Martin on 4 Feb 2010 15:53
sorry, I forgot to told you that I have tried this too, i'm stuck with my
problem maybe unistall and reinstall Ofiice will set the problem ?
--
Martin Verville


"Gord Dibben" wrote:

> Sounds like your numbers are Text.
>
> Format to General or Number then copy an empty cell.
>
> Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 4 Feb 2010 11:22:01 -0800, Martin <Martin(a)discussions.microsoft.com>
> wrote:
>
> >Does'nt matter A1 can be as simple as 1 and A2 as 2, and it return zero
> >onstead of tree.
> >
> >I've tried with a couple different excel file in the company and i'm at the
> >same point, always the same problem.
>
> .
>
 |  Next  |  Last
Pages: 1 2 3
Prev: Text data -- linking Excel sheets
Next: Can I title columns with out them having a row number?