Unary + Operator

Hi ,

Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? .


Thanks in advance
Xcelion

On Sat, 8 Oct 2005 05:54:54 -0500, xcelion
<[email protected]> wrote:

>
>Hi ,
>
>Can anyone tell me what is the use of unary operator + in formulas(like
>=+B4) .What does it mean? .
>
>

It is completely unnecessary in Microsoft Excel in that formula.

You would have to ask the particular user for his reason.


--ron

It means that the person who wrote it used to use Lotus, and has not
become that proficient in Excel.

Jerry

xcelion wrote:

> Hi ,
>
> Can anyone tell me what is the use of unary operator + in formulas(like
> =+B4) .What does it mean? .

As Jerry said, they are a hang over from someone's Lotus days. If they bug
you (and they do me), you can probably do a find and replace on your sheet,
replacing =+ with =

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"xcelion" <[email protected]> wrote in
message news:[email protected]...
>
> Hi ,
>
> Can anyone tell me what is the use of unary operator + in formulas(like
> =+B4) .What does it mean? .
>
>
> Thanks in advance
> Xcelion
>
>
> --
> xcelion
> ------------------------------------------------------------------------
> xcelion's Profile:
> http://www.excelforum.com/member.php...o&userid=16287
> View this thread: http://www.excelforum.com/showthread...hreadid=474454
>

We had a secretary at work who habitually started formulas with a '+' and
she had never even heard of Lotus! When asked why she did it she said. it
"just seenmed right"

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> As Jerry said, they are a hang over from someone's Lotus days. If they
> bug you (and they do me), you can probably do a find and replace on your
> sheet, replacing =+ with =
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------*------------------------------*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------*------------------------------*----------------
>
>
> "xcelion" <[email protected]> wrote in
> message news:[email protected]...
>>
>> Hi ,
>>
>> Can anyone tell me what is the use of unary operator + in formulas(like
>> =+B4) .What does it mean? .
>>
>>
>> Thanks in advance
>> Xcelion
>>
>>
>> --
>> xcelion
>> ------------------------------------------------------------------------
>> xcelion's Profile:
>> http://www.excelforum.com/member.php...o&userid=16287
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=474454
>>
>
>

LOL :-)

"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
> We had a secretary at work who habitually started formulas with a '+' and
> she had never even heard of Lotus! When asked why she did it she said. it
> "just seenmed right"
>
> --
> HTH
>
> Sandy
> [email protected]
> Replace@mailinator with @tiscali.co.uk
>
>
> "Ken Wright" <[email protected]> wrote in message
> news:[email protected]...
>> As Jerry said, they are a hang over from someone's Lotus days. If they
>> bug you (and they do me), you can probably do a find and replace on your
>> sheet, replacing =+ with =
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*----------------
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*----------------
>>
>>
>> "xcelion" <[email protected]> wrote in
>> message news:[email protected]...
>>>
>>> Hi ,
>>>
>>> Can anyone tell me what is the use of unary operator + in formulas(like
>>> =+B4) .What does it mean? .
>>>
>>>
>>> Thanks in advance
>>> Xcelion
>>>
>>>
>>> --
>>> xcelion
>>> ------------------------------------------------------------------------
>>> xcelion's Profile:
>>> http://www.excelforum.com/member.php...o&userid=16287
>>> View this thread:
>>> http://www.excelforum.com/showthread...hreadid=474454
>>>
>>
>>
>
>