Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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 !


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I CONVERT SCANNED DOCUMENT IN PDF FORMAT BACK TO AN EXCEL. eyetye Excel Discussion (Misc queries) 2 December 3rd 04 06:33 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 02:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 02:55 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"