if you see 1/1/1900.. all u need to do is 1. Rt Click 2. Format cells 3. select General (it will be date by default what why it showed that 1/1/1900) hope this helps!