View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Formula starts =+(cell reference)

It's a carryover from 123. Usually it is harmless to leave it in. Also some
parenthesis are unnecessary
Examples:
=+a1, =a1
=+C:\Excel\[WB]Sheet1!A1,
=+L187+(Q213), =l187+q213
=+Sum(A1:A33) =sum(etc

--
Don Guillett
SalesAid Software

"chaunceycupoo" wrote in message
...
Can anyone provide a detailed explanation of what it means when a formula
is
input into a cell with the addition sign immediately after the =.

Examples: =+a1, =+C:\Excel\[WB]Sheet1!A1, =+L187+(Q213), =+Sum(A1:A33)

I inherited several spreadsheets that I am revising that use this
convention
and I can't seem to find any information on what it means other then a
note
in Excel for Dummies stating this means you want to make the value
"explicitly positve"

Does anyone have more information on this. Thanks in advance for any help.