Help Q: Entering 7 p time format, does not convert to 19:00

[ANONRW]

Hi,

I am running excel 2002, and when I open a new spreadsheet, and enter a time
into a cell as 7 p it gets converted to 19:00

I have taken a spreadsheet file someone has given me, and reformatted it.
but whenever I enter a time like 7 p it shows up as 7 p
if I enter 7 pm it does get converted to 19:00

Is there a setting in the sheet itself somewhere to change this behavior ?
I have searched all over, and can find no reference to this.

Please help - TIA !

 

[Frank Kabel]

Hi
probably differences in the Windows regional settings for both machines