Several spreadsheets I use spontaneously change from number formats to date formats. I have tried everything to make Excel keep the formatting I assign, but when I save, close and re-open, the format changes back to date. Not every time, but most of the time. The "Normal" style reverts back to date. Why does this happen and what can be done to prevent it?
Bookmarks