Using Excel 2007

I have rows with numbers that continuously revert to the "Date" setting in the "Number" tab from the "Normal" setting. I can select the entire row and select "Normal" and everything is fine for the moment. But when I close out and reopen the file the same occurs, not everytime but quite often. Due to security reasons, we are forced to "Enable" macros evertime the file is opened.

I've seen a similiar post (see below) and the answer was select "Normal" and proceed. But that doesn't correct the problem permanently which is what I want to do, fix it so the row I want to be permanently "Normal" stays that way.

Thank you for your help!


Previous Post:

All of a sudden every empty cell, and any cell not specically formated, in
every worksheet has a default cell format of Date. Every blank column and row or any cell with not a specific format.

How did the default cell format for this workbook become set to 'Date' from
'General' and how do i fix it?

Any new workbook created is OK.. defaults to 'General' - But, if I add a new
blank worksheet to this particular workbook... it defaults to 'Date' format.