View original (French)

Excel calendar stuck on dates 1900

Anonymous user -  
brucine Posted messages 24785 Registration date   Status Member Last intervention   -

Good evening, could someone tell me how to get Excel to display the current date instead of the 1900 or 1904 dates?
Thank you and have a good evening.

1 answer

  1.
    brucine Posted messages 24785 Registration date   Status Member Last intervention   4 161
     

    Hello,

    The Excel calendar starts by default in 1900, in 1904 if you choose it in Advanced options.

    In both cases, if the cell has a value 0 by nature or by Excel calculation, Excel will go back to its source and display the initial date, same if a cell is poorly formatted so that Excel cannot perform the calculation and takes 0 by default.

    The current date cannot be "initialized" if the result comes from the TODAY() function; if I introduce it inline, Excel will automatically and correctly recognize some separators for example dd-mm-yy, but not others like ddmmyy or dd mm yy.

    The error then occurs if it is not a calculation probably due to data copied from an external source and Excel does not understand it.

    0