Excel 2010 Automatically converting cells to "Accounting"

[enderzero]

Apologies if this has been covered - I did a search but came up empty.

I have a large spreadsheet I created in Excel 2007. Now that I have upgraded to 2010 I am seeing some very annoying behavior where when I type in a cell and enter the data it is converting the cell type to "Accounting" thus losing my formatting (placing a space before, losing center justification, decimal settings, etc.). This seems to be happening whether I am entering numbers or text and I have to reset the cell type to general after each entry.

I've tried selecting all, ranges, and individual cells and converting them to general - which sometimes works - but often once I enter data it starts happening again.

Any idea if there is a way to fix this, a setting, etc.? Anyone else had this issue.

Thanks

 

[Derek Brown]

The following may be of interest and could help you find a solution:
http://www.mrexcel.com/forum/showthread.php?t=475027
http://www.mrexcel.com/forum/showthread.php?t=541059
http://www.mrexcel.com/forum/showthread.php?t=549170
The styles will be found on the Home TAB; right mouse-click 'Normal' and select 'Modify' to see and/or change the format.