View original (French)

Excel calendar stuck on dates 1900

Google@101871291544985980670 Posted messages 1 Registration date   Status Member Last intervention   -  
brucine Posted messages 24727 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

Answer 1 / 1
brucine Posted messages 24727 Registration date   Status Member Last intervention   4 152
 

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