I want to stop excel deciding the number format of a cell for me
 

If i enter a formula that returns a text result (eg =c2 where cell c2
contains text), then Excel defaults that cell's number format to text.
This means that next time I edit that formula, I just get the text "=c2".
To get the result I want I need to reformat that cell back to general, then
click back in the edit formula bar. This is frustrating and tedious when it
happens a lot.
I want to set all cell number formats to general unless I specifically
overide that, so that I don't have excel deciding for me that a particular
cell should be text when it should still be general.
I hope all this makes sense.