I’m using Excel 2007 I need to keep formatting to text

I know about protecting the worksheet which would work if I didn’t need to use the text to column feature. Excel changes 12-** to general formatting giving me a number I don’t want. Does anyone have any suggestions?