Hello Experts,
After a lot of search on Google, I had to post this question here since I couldn't find an answer or solution to this problem. My excel sheet is displaying the date and time in the following format in the cells. But, when I click the individual cell, the top function bar column is showing date and time in the 1900 formats instead of the current dates, which is weird. Could someone please help me with this?
PS: I've tried formatting the cells to date, time, custom etc but still no use.
Actual Display:
720:00:00 |
744:00:00 Display in the function bar: 1/30/1900 12:00:00 AM 1/31/1900 12:00:00 AM Thanks! |