How to correct the display date and time from 1900 version in Excel-2010?

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!
July 17th, 2015 5:25pm
Dates in Excel start at zero being 12/31/1899 at midnight. So 720 hours is 30 days is 1/30/1900 at midnight, and that is the default display of dates in the formula bar. So there is nothing incorrect about your display. If you change your format to Number both the cell and the formula bar will show just 30.
  • Proposed as answer by André Santo Friday, July 17, 2015 7:27 PM
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2015 7:25pm
Dates in Excel start at zero being 12/31/1899 at midnight. So 720 hours is 30 days is 1/30/1900 at midnight, and that is the default display of dates in the formula bar. So there is nothing incorrect about your display. If you change your format to Number both the cell and the formula bar will show just 30.
  • Proposed as answer by André Santo Friday, July 17, 2015 7:27 PM
  • Marked as answer by Bangaaram 15 hours 20 minutes ago
July 17th, 2015 7:25pm

Hi

This is the forum to discuss questions about Microsoft Excel (VSTO, VBA) develop. For your question is about features in Excel, I will move this question to forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards,

Lan


Free Windows Admin Tool Kit Click here and download it now
July 20th, 2015 5:26am

Thanks, Bernie :-)

Sure, Lan. I believe I couldn't find the Excel forum initially. So, had to post it in a different forum.

July 21st, 2015 12:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics