I RECENTLY RECEIVED AN E-MAIL WITH A ZIPPED EXCEL WORKBOOK ATTACHED, WHICH I
SAVED IN EXCEL. APPARENTLY ALL OF THE FORMULAS IN THIS WORKBOOK WERE
CONVERTED TO TEXT. NOW EVERY EXCEL WORKSHEET THAT I OPEN OR CREATE ACTS AS
THOUGH ALL FORMULAS ARE TEXT. I.E., I ENTER A FORMULA IN THE FIRST COLUMN
AND TRY TO DRAG IT TO SUBSEQUENT COLUMNS. THE SUBSEQUENT COLUMNS CONTAIN THE
FORMULA AS TEXT. DRAGGING THE FORMULA FROM THE INITIAL COLUMN ENTRY COPIES
THE VALUE OF THE RESULT OF THAT COLUMN TO ALL OTHER COLUMNS. IF THE SAME
FORMULA IS ENTERED IN ALL COLUMNS, ENTERING ADDITIONAL DATA IN A COLUMN DOES
NOT CHANGE THE TOTAL. IT IS NECESSARY TO REENTER THE SAME FORMULA AT THE
BOTTOM OF THE COLUMN AGAIN IN ORDER TO GET THE INSERTED ADDITIONAL DATA TO BE
REFLECTED IN THE SUM.