Plus sign in front of a formula

Hi,

I have a simple question here, I am looking at a spreasheet and there is a plus sign in front of all the sum formulas, ex: =+SUM(E28;E30), what does it mean? Thanks for the help.

Marcos

I'm still used to starting formulas off with a plus sign to indicate I want the cell to be a formula. I think this was one way you could do it in old forms of excel. Nowadays all formulas begin with an equals sign. If you begin a formula with anything like a + or a - now, excel automatically puts the = in. Thus you can end up with formulas beginning =+.

Not sure but I think this is why.

Thanks Timmy.

Marcos

It is a holdover from Lotus 123 compatibility. It serves no
purpose in Excel, but is harmless if included.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Timmy Mac1"
<[email protected]> wrote
in message
news:[email protected]...
>
> I'm still used to starting formulas off with a plus sign to
> indicate I
> want the cell to be a formula. I think this was one way you
> could do it
> in old forms of excel. Nowadays all formulas begin with an
> equals sign.
> If you begin a formula with anything like a + or a - now, excel
> automatically puts the = in. Thus you can end up with formulas
> beginning =+.
>
> Not sure but I think this is why.
>
>
> --
> Timmy Mac1
> ------------------------------------------------------------------------
> Timmy Mac1's Profile:
> http://www.excelforum.com/member.php...o&userid=15188
> View this thread:
> http://www.excelforum.com/showthread...hreadid=477896
>