Cannot format cells for time

[steu]

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 Custom with Type=h:mm, same result.

Is this some kind of a known bug? If not, how do I format cells to be Type=13:30  ?

Thanks

[#2]

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.

[#3]

---

@steu wrote:

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 Custom with Type=h:mm, same result.

Is this some kind of a known bug? If not, how do I format cells to be Type=13:30  ?

Thanks

---

Hi, as you want to set the time format 13:30 (military time format) in cell, then

- Type 13:30 in any cell assume that A1 cell.

- Click on A1 cell to select it.

- Look at the formula bar and make sure that it shows 1:30:00 PM.

- If it shows, then your time format is already set. If not then you must clear the Cell Formatting by copy and paste a fresh blank cell in A1.

Hope this will help you.

[#4]

win10excel2016: having the same problem!!!! hhmm simply is not an option. No matter what I do, including creating a fresh new custom time format, I still get the, by now, very unwelcomed date that messes things up completly urs (useless...)