ExcelBanter - Enter Formula without using =

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Enter Formula without using = (https://www.excelbanter.com/new-users-excel/189668-enter-formula-without-using-%3D.html)

Brian Tankersley

Enter Formula without using =

I would like to be able to enter a formula into a cell and have it not
require me to first type the equals sign.

For example, when I type

12+12

I would like for the cell to return

24

and when I edit the cell, it would show

=12+12

(e.g. Excel automatically inserts the = before the formula)

Does anyone know how to do this?

Peo Sjoblom

Enter Formula without using =

Toolsoptionstransition and select transition formula entry

--

Regards,

Peo Sjoblom

"Brian Tankersley" wrote in message
...
I would like to be able to enter a formula into a cell and have it not
require me to first type the equals sign.

For example, when I type

12+12

I would like for the cell to return

24

and when I edit the cell, it would show

=12+12

(e.g. Excel automatically inserts the = before the formula)

Does anyone know how to do this?

All times are GMT +1. The time now is 12:00 AM.