Formating a cell in Excell

[Skiermom]

Several years ago I created an excell worksheet wherein I formatted cells so
that you didn't have to enter the = sign before preforming a calculation
within that cell, e.g. you could add two numbers together without placing the
= sign in front. I am unable to remember how I did this. Does anyone have
any idea how I might have formatted the cells?

[Kevin Vaughn]

Actually, it is Tools/Options/Transition then check Transition Formula Entry.
Interestingly, this only appears to change the worksheet that you make this
change in. A different sheet within the same workbook will continue to use
Excel's formula entry rules.

--
Kevin Vaughn


"Skiermom" wrote:

> Several years ago I created an excell worksheet wherein I formatted cells so
> that you didn't have to enter the = sign before preforming a calculation
> within that cell, e.g. you could add two numbers together without placing the
> = sign in front. I am unable to remember how I did this. Does anyone have
> any idea how I might have formatted the cells?
>
>

[Skiermom]

Kevin,

Thanks for the quick reply. It was so long ago that I created a worksheet
using the transition formula entry tab that I forgot how to do it. Thanks
for the info.

"Kevin Vaughn" wrote:

> Actually, it is Tools/Options/Transition then check Transition Formula Entry.
> Interestingly, this only appears to change the worksheet that you make this
> change in. A different sheet within the same workbook will continue to use
> Excel's formula entry rules.
>
> --
> Kevin Vaughn
>
>
> "Skiermom" wrote:
>
> > Several years ago I created an excell worksheet wherein I formatted cells so
> > that you didn't have to enter the = sign before preforming a calculation
> > within that cell, e.g. you could add two numbers together without placing the
> > = sign in front. I am unable to remember how I did this. Does anyone have
> > any idea how I might have formatted the cells?
> >
> >

[Kevin Vaughn]

You're welcome.
--
Kevin Vaughn


"Skiermom" wrote:

> Kevin,
>
> Thanks for the quick reply. It was so long ago that I created a worksheet
> using the transition formula entry tab that I forgot how to do it. Thanks
> for the info.
>
> "Kevin Vaughn" wrote:
>
> > Actually, it is Tools/Options/Transition then check Transition Formula Entry.
> > Interestingly, this only appears to change the worksheet that you make this
> > change in. A different sheet within the same workbook will continue to use
> > Excel's formula entry rules.
> >
> > --
> > Kevin Vaughn
> >
> >
> > "Skiermom" wrote:
> >
> > > Several years ago I created an excell worksheet wherein I formatted cells so
> > > that you didn't have to enter the = sign before preforming a calculation
> > > within that cell, e.g. you could add two numbers together without placing the
> > > = sign in front. I am unable to remember how I did this. Does anyone have
> > > any idea how I might have formatted the cells?
> > >
> > >