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

Hi
probably differences in the Windows regional settings for both machines

--
Regards
Frank Kabel
Frankfurt, Germany

"ANONRW" schrieb im Newsbeitrag
...
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 !