View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default why use + sign in following formula? =+Q290*10

Mike H wrote...
It's a throwback to LOTUS 123 and is tolerated by Excel but serves no
useful purpose. Simply use =

....

Does make one wonder why Excel can't strip it off since Excel does
strip off unary + from numeric literals and Excel strips off @ chars
before function names.