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
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.
Thank you for your response. It is Excel 2016
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.
Hello Velouria,
I tried it, Even the style getting changed again and again.
Thank you,
Krishna
