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 !
|