Disappearing numbers

Hi khank,

By the word "quark" as a problem or error or bug, lets think about it. Excel has been dealing with these problems for about 20 years and have improved their code with each new release and each Office SP.

Read how they must infer what the customer has based on what is in the cell in 2003 Excel at:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
This was 7 years ago.

I think they are more correct than us about how they deal with things. All we have to do is understand their reasoning and follow it.

In the past, in doing Pivot Tables I get a count instead of a Sum, like I'd expect. It is normally because I have some text in the middle of my numbers. I believe there are very few "quarks" left in the Excel logic.