Simple Question, But No Answer
 

I have a cell in a worksheet that is returning the correct answers, but I
can't figure out why the function is written like it is. Here it is:

=+L23

This properly gives the result of the value in cell L23. But why the plus
sign in front of the cell's address?

Joe in Sacramento

Simple Question, But No Answer
 

It is a throwback to Lotus 1-2-3, not necessary, you can remove it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Joe Teixeira" wrote in message
...
I have a cell in a worksheet that is returning the correct answers, but I
can't figure out why the function is written like it is. Here it is:

=+L23

This properly gives the result of the value in cell L23. But why the plus
sign in front of the cell's address?

Joe in Sacramento

Simple Question, But No Answer
 

This is a feature of Excel for people who do 10-key. Instead of using = to
begin a formula, you can use +. Excel automatically inserts the =. I think
it is also a compatability feature with other spreadsheet programs?

"Joe Teixeira" wrote:

I have a cell in a worksheet that is returning the correct answers, but I
can't figure out why the function is written like it is. Here it is:

=+L23

This properly gives the result of the value in cell L23. But why the plus
sign in front of the cell's address?

Joe in Sacramento