Log In
Register
Home
Active Member
April 27, 2022
Offline
Hello,
I have few excel files, when I open them all cells in all sheets change to date or custom format. I change the format to general, save and close still when I open the file again the format changes to date/custom. It will be great help if I get a solution for this issue.
Thank you,
Krishna
Trusted Members
Moderators
November 1, 2018
Offline
Which version of Excel is it? That sounds like a bug that first appeared in (I think) Excel 2007 where the normal style's number format would be changed to date. There were lots of possible causes - often seemed to involve files with lots of pivot tables - but nothing definitive as I recall.
Active Member
April 27, 2022
Offline
Thank you for your response. It is Excel 2016
Trusted Members
Moderators
November 1, 2018
Offline
There has never been a definitive cause identified that I know of but to correct it you need to modify the Normal style (under cell styles on the Home tab) to make the default number format General again.
1 Guest(s)
