Excel standard cell format changes to Jan-00
Solved
kaetl
-
kaetl -
kaetl -
Hello,
Congratulations on this site - In Excel 2007: in some places of my tables, the cell format changes upon reopening the file. From the standard format, the display format of certain cells only becomes Jan.-00. The calculations and formulas work correctly. Of course, I have searched through forums and thoroughly checked the formats, but I remain without answers. So, a huge thank you to anyone who can help me.
Kaetl
Configuration: Windows XP / Internet Explorer 6.0
Congratulations on this site - In Excel 2007: in some places of my tables, the cell format changes upon reopening the file. From the standard format, the display format of certain cells only becomes Jan.-00. The calculations and formulas work correctly. Of course, I have searched through forums and thoroughly checked the formats, but I remain without answers. So, a huge thank you to anyone who can help me.
Kaetl
Configuration: Windows XP / Internet Explorer 6.0
4 answers
Hello
you should have date-format cells nearby that automatically realign the neighbors, whose numerical value should be 0
try this:
Click on the Microsoft logo at the top left
at the bottom of the window: Excel options
list on the left: advanced options and in the first table, check that the line
extend formulas and formats of data ranges is unchecked;
crdlmnt
Let's ask ourselves if we are not alone in understanding what is being explained?
you should have date-format cells nearby that automatically realign the neighbors, whose numerical value should be 0
try this:
Click on the Microsoft logo at the top left
at the bottom of the window: Excel options
list on the left: advanced options and in the first table, check that the line
extend formulas and formats of data ranges is unchecked;
crdlmnt
Let's ask ourselves if we are not alone in understanding what is being explained?
Hello,
Strange but relevant, can you make your file available to us if it doesn't contain any confidential notes, and check if there’s no VBA underneath
to attach with this link
https://www.cjoint.com/
--
See you soon
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Strange but relevant, can you make your file available to us if it doesn't contain any confidential notes, and check if there’s no VBA underneath
to attach with this link
https://www.cjoint.com/
--
See you soon
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.