The curly brackets {} indicate an array formula. When you edit the formula
in the formula bar, these disappear. Here's some info on array formulas:
http://www.cpearson.com/excel/array.htm

Dave


--
Brevity is the soul of wit.


"svemor" wrote:

In my sheet all the formulas has { } around them. E.x:

{=COUNT(IF(Data!$M$2:$N$655360;IF(Data!$O$2:$O$65 536=$A3;IF(YEAR(INT(Data!$L$2:$L$65536))=2006;Data !$M$2:$N$65536))))}

When I enter the formula line the {} disapper, and the formula no longer
returns the same value. Thers no change to the formula or the values in the
refering cells.

Any suggestions?