I've used Excel more than I care to think about, but this is a new one for me. I have a cell with a simple formula,
=Counts!E3. I set the number format to General. I edit the cell (just F2-Enter, no change). The formula no longer works, and when I check the number format, it's now Text.
Has anyone else seen this behavior? Maybe found a fix? I can change the format to General and hope no one touches it (or set up worksheet protection), but if there's a hotfix or something that would be groovytacular.