View original (French)

Excel standard cell format changes to Jan-00

Solved
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

4 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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?
    2
  2. jfqld Posted messages 8725 Registration date   Status Member Last intervention   127
     
    It should send the table
    --
    I will drink milk when the cows eat grapes.
    0
  3. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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.
    0
  4. kaetl
     
    Good evening Vaucluse - the neighboring cells are not 0 but on one side of the text, on the other a formula. Unchecking the "extend formulas..." box seems to have prevented this inconvenience. Thank you - Thanks also to Mike 31 and jfqld.
    0