This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a problem with my excel spreadsheet changing the format when I reopen the file. It does not affect every cell, only some. The fomatting changes from general to a date format. The only way I've found to keep this from reoccurring is to change the format of each and every affected cell individually. This took hours, as my spreadsheet tracks military vehicles. this continues to affect cells in new columns and rows. does anyone know how to stop this formatting chnage from happening all by itself??? This started after our computers were "upgraded" from Windows XP to Windows 7.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Yes, it is. I ended up changing all the "general" cell formats to either text format or number format. It has been about a week, and so far, so good. No additional unwanted formatting changes. I know how time consuming it is to have to fix the formats on all the cells. Good luck with yours, and thank you for your reply.
Sorry, but you clearly did not read the question.
I have the same issue as describe above, but in my case the cell format is changed to Accounting.
This behaviour is very unpredictable and very time consuming to correct (each time the file is re-opened).
Check the Windows Regional setting so see what you have fro default date fromat. best wishes