Cell Format
Solved
nauzia45
Posted messages
356
Status
Member
-
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Hello,
Out of 356 files, only one has an anomaly that I can't fix.
This file ("Electricity") contains about thirty sheets. For several months now, all the empty cells are in 'Date' format; when I insert a new sheet, it’s the same.
I checked in "File"; I couldn't find anything to solve my problem.
Very, very curiously, this file, created several years ago, did not have this issue when it was created; I don’t understand anything!
If you have any ideas, thank you in advance for your welcome help.
Have a good evening.
Configuration: Windows / Chrome 63.0.3239.132
Out of 356 files, only one has an anomaly that I can't fix.
This file ("Electricity") contains about thirty sheets. For several months now, all the empty cells are in 'Date' format; when I insert a new sheet, it’s the same.
I checked in "File"; I couldn't find anything to solve my problem.
Very, very curiously, this file, created several years ago, did not have this issue when it was created; I don’t understand anything!
If you have any ideas, thank you in advance for your welcome help.
Have a good evening.
Configuration: Windows / Chrome 63.0.3239.132
1 answer
-
Hello,
Check that you haven't modified the normal style:
1) Cell styles / 2) right-click on normal / 3) modify / 4) check the number format of the Normal style
If it is not set to Standard: 5) Modify
--
Best regards
Patrice-
Hello Patrice,
Well ... you're good!
I had never done this manipulation; and the number format is really hidden. I tried it twice because your illustration, which is very educational, doesn't quite match my version of Excel 2010; but it works. I will be a little less ignorant!
Thank you for your quick response and the time you dedicated to it.
Have a good day. -
-
