I type "=A1+B1" in cell C1.

Cell C1 displays "=A1+B1", not the result of the formula.

Tried CTRL +` but that just seems to make the colums thinner.

It's driving me nuts!

Can anyone help?

Jeff

Hi Jeff...
There is either TWO things happening...

1. Remove the quotations...unless you posted them here for display
purposes.

OR

2. Go to TOOLS/OPTIONS on the VIEW tab (at the bottom) Window
Options...Uncheck the box that reads FORMULAS.

Let me know how you make out.

Jenni





Jeff Granger wrote:
> I type "=A1+B1" in cell C1.
>
> Cell C1 displays "=A1+B1", not the result of the formula.
>
> Tried CTRL +` but that just seems to make the colums thinner.
>
> It's driving me nuts!
>
> Can anyone help?
>
> Jeff

Format your cell as something other than Text, then reenter the formula.

In article <BaidnUWeDcHbG8HYnZ2dnUVZ8s-(E-Mail Removed)>,
"Jeff Granger" <(E-Mail Removed)> wrote:

> I type "=A1+B1" in cell C1.
>
> Cell C1 displays "=A1+B1", not the result of the formula.
>
> Tried CTRL +` but that just seems to make the colums thinner.
>
> It's driving me nuts!
>
> Can anyone help?
>
> Jeff

Jenni

Yes, the quotes were just for clarity, I didn't actually type them in.

Tools | Options | Formulas is unchecked, so it must be something else ??

Jeff


"Jenn" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Jeff...
> There is either TWO things happening...
>
> 1. Remove the quotations...unless you posted them here for display
> purposes.
>
> OR
>
> 2. Go to TOOLS/OPTIONS on the VIEW tab (at the bottom) Window
> Options...Uncheck the box that reads FORMULAS.
>
> Let me know how you make out.
>
> Jenni
>
>
>
>
>
> Jeff Granger wrote:
>> I type "=A1+B1" in cell C1.
>>
>> Cell C1 displays "=A1+B1", not the result of the formula.
>>
>> Tried CTRL +` but that just seems to make the colums thinner.
>>
>> It's driving me nuts!
>>
>> Can anyone help?
>>
>> Jeff
>

I wish Jeff...that's all I can think of. Is this the only workbook it
does it in...or everyone you open?

Jenn



Jeff Granger wrote:
> Jenni
>
> Yes, the quotes were just for clarity, I didn't actually type them in.
>
> Tools | Options | Formulas is unchecked, so it must be something else ??
>
> Jeff
>
>
> "Jenn" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi Jeff...
> > There is either TWO things happening...
> >
> > 1. Remove the quotations...unless you posted them here for display
> > purposes.
> >
> > OR
> >
> > 2. Go to TOOLS/OPTIONS on the VIEW tab (at the bottom) Window
> > Options...Uncheck the box that reads FORMULAS.
> >
> > Let me know how you make out.
> >
> > Jenni
> >
> >
> >
> >
> >
> > Jeff Granger wrote:
> >> I type "=A1+B1" in cell C1.
> >>
> >> Cell C1 displays "=A1+B1", not the result of the formula.
> >>
> >> Tried CTRL +` but that just seems to make the colums thinner.
> >>
> >> It's driving me nuts!
> >>
> >> Can anyone help?
> >>
> >> Jeff
> >

That did it!

Thanks

Jeff
"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> Format your cell as something other than Text, then reenter the formula.
>
> In article <BaidnUWeDcHbG8HYnZ2dnUVZ8s-(E-Mail Removed)>,
> "Jeff Granger" <(E-Mail Removed)> wrote:
>
>> I type "=A1+B1" in cell C1.
>>
>> Cell C1 displays "=A1+B1", not the result of the formula.
>>
>> Tried CTRL +` but that just seems to make the colums thinner.
>>
>> It's driving me nuts!
>>
>> Can anyone help?
>>
>> Jeff