how can I restore Edit button to the Formula bar?

I can't put back the Edit button on the Formula bar, the Function button has
taken over.

JJ

Do you mean the "=" sign on the formula bar?

It left Excel when version 2002(XP) was released and no workaround for it.

If you are running an older version, I don't know how it got lost.

I can run Version 97 and cannot lose the "Edit Formula" button(= sign).


Gord Dibben Excel MVP


On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
<JJKatty@discussions.microsoft.com> wrote:

>I can't put back the Edit button on the Formula bar, the Function button has
>taken over.

thank you! Finally an answer! Yes I did upgrade Excel to 2002 and thats when
I lost the "=" button, I like it more than the function button. JJ

"Gord Dibben" wrote:

> JJ
>
> Do you mean the "=" sign on the formula bar?
>
> It left Excel when version 2002(XP) was released and no workaround for it.
>
> If you are running an older version, I don't know how it got lost.
>
> I can run Version 97 and cannot lose the "Edit Formula" button(= sign).
>
>
> Gord Dibben Excel MVP
>
>
> On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
> <JJKatty@discussions.microsoft.com> wrote:
>
> >I can't put back the Edit button on the Formula bar, the Function button has
> >taken over.
>
>

JJ

You and a whole other bunch of people<g>

Try dragging the "=" sign up to the toolbar and click on it to enter "=" then
click on the Name Box at left of formula bar.

Select your Function(s) from there.

Saves a few steps.

"=" sign can be found under Tools>Customize>Commands>Insert category.


Gord

On Fri, 25 Mar 2005 18:23:01 -0800, "johnjrider"
<johnjrider@discussions.microsoft.com> wrote:

>thank you! Finally an answer! Yes I did upgrade Excel to 2002 and thats when
>I lost the "=" button, I like it more than the function button. JJ
>
>"Gord Dibben" wrote:
>
>> JJ
>>
>> Do you mean the "=" sign on the formula bar?
>>
>> It left Excel when version 2002(XP) was released and no workaround for it.
>>
>> If you are running an older version, I don't know how it got lost.
>>
>> I can run Version 97 and cannot lose the "Edit Formula" button(= sign).
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>> On Fri, 25 Mar 2005 11:25:03 -0800, "JJKatty"
>> <JJKatty@discussions.microsoft.com> wrote:
>>
>> >I can't put back the Edit button on the Formula bar, the Function button has
>> >taken over.
>>
>>