Huge cell formatting issue - everything is suddenly formatted as"date"!

I badly need some advice. I have been working on the project for several months.  I have  two sheets with numeral and text information in them and a bunch of formulas running accross the two.  Alot o...