Forum Discussion
Cannot format cells for time
I am using Office 2010 w. Windows 10. I want to format cells for TIME. I select Format cells, Time and then Type= 13:30. Whatever I enter comes up as 1/11/1900 12:00:00. I also tried to use C...
Hi steu,
In my PC also, it shows year 1900, but time comes correctly.
Try "Ctrl + Shift + ;"
Then change to your custome time and apply format as you want.