View Single Post
  #1   Report Post  
Frank Kabel
 
Posts: n/a
Default 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 !