I typed "2:30pm" into a cell in a Google sheet, and it formatted it as "2:30 PM". I typed "2:30pm" into a different cell, and it formatted it as "14:30".
What I Want To Know:
These were both cells in a new sheet and I hadn't typed anything into either of them before. Why might each get autoformatted differently?
I clicked on the "2:30 PM" one to try and see what format had been applied to it, in order to try and format the "14:30" one the same way. How do I tell what the current formatting on a cell is, such that I could apply the same formatting to other cells?