Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I CONVERT SCANNED DOCUMENT IN PDF FORMAT BACK TO AN EXCEL. | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |