equal sign on the formula bar gone

[Federico Borrego E.]

In the PC version of Excel there used to be an equal sign on the formula
bar to rapidly change a number into a formula for calculations and stuff.
Now it¹s gone. Someone knows how to get it back there?

Thanks,

Mr. Borrego

 

[Norman Harker]

Hi Federico!

Try:

Tools > Customize > Commands Tab > Insert classification
Select the = and drag it up to a toolbar
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

Hi Norman,

I don't think that what the OP wanted in his multipost, I believe he wants
the functionality of the equal sign pre 2002 where it started a formula with
the contents of
the selected cell. This equal sign replaces what's in the selected cell.

 

[Norman Harker]

Hi Peo!

Right! Never used it. I find that Debra covered this in a post:

Quote >>
No, the Equal Sign button is gone, and there's no way to replace it in
Excel 2002. You may find the following thread interesting:
http://groups.google.com/groups?&threadm=04fb01c29ae3$86f4d080$8df82ecf@TK2MSFTNGXA02

<<End Quote


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Peterson]

You could create macro and add a custom button to your favorite toolbar.

the macro could look something like:

Option Explicit
Sub addEquals()
SendKeys "{F2}{Home}={End}"
End Sub