2025 January Calendar Excel Cell Value Not Showing

2025 January Calendar Excel Cell Value Not Showing. If a cell has the value 0 and is formatted as a date then it will show as 1/0/1900. Since your source cells contains either a year or an actual date you can try using this:

A cell with 1/0/1900 has a format of date not general. You can separate the time from the date to fix this issue.