| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 79206 | 2007-05-12 00:11:00 | Excel 2007 cell problem | Bryan (147) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 549225 | 2007-05-12 00:11:00 | I have a small spreadsheet that I am having problems with. I have formatted the dates as 01/08/2006, that date appears in the format line as 1/8/2006. In the cell, the date appears as 8/1/2006 and there seems to be no way that this can be changed even by using all of the options in the "Format cells" option. There are other cells that display the correct dates but even copying them into the rogue cell and then changing the date:help: I still get the wrong result. Anyone got any ideas please? |
Bryan (147) | ||
| 549226 | 2007-05-12 03:00:00 | Have you checked your Regional Settings under Control Panel to make sure that the Regional Options/Standards and Formats are set to English (New Zealand) | TeejayR (4271) | ||
| 549227 | 2007-05-12 04:05:00 | Thanks TeejayR. Yes I did that. | Bryan (147) | ||
| 1 | |||||