Excel 2010 Question

Sorry Google not cooperating with me 🙁

The only thing I use excel for is technical documents, so every time excel decides to turn a date into a 5 digit number, or a 1% value into 0.01, I want to shoot Balmer.

Made worse by the fact that if you convert to text, it converts the changed values, it doesn’t put back what you had before. So 01/01/2001 becomes 36892 when you convert the date to text.

Is there a way to permanently make excel always format all cells to text when you start a new worksheet? So it doesn’t keep doing this to me?

Thanks.