I'm not even sure if I can explain this problem properly...but I'll try.
Excel is only recognizing numbers as text, and this has only begun as of today. Yesterday, I had a series of numbers that would be sorted by a macro. I hit the button, they would be placed in sorted order...all would be well. Now, the sorting isn't working properly. When I sort manually, it says something like there are some fields formatted as text. I can even highlight all fields, format as number, and try to resort, but get the same error.
Furthermore, whenever I paste values into my worksheet, I have to go through each cell, clicking into the formula box and hitting enter to update the value before it will correct the formula result. Yes, I do have automatic calculation on...that's the first thing I thought of.
Please help! None of this is making sense!!