re: XP and Excel Sunday, December 9, 2001 at 11:24 pm Windows XP Annoyances Discussion Forum Posted by Hugh (1 messages posted) right click on the cells and goto format cells. under the "numbers" tab pick "date" and you can format the date and location On Sunday, December 9, 2001 at 2:43 pm, tony wrote: >My Excel workbooks contain dates using the UK format (ie. 6/1/01 = 6 Jan 2001. In >Windows 98, this displayed correctly in each cell. Now in Excel/XP if I enter 6/1/01 >it interprets as 1 Jun 2001. My Regional settings are all OK, but I can't find anywhere >in Excel to change this to the UK format. Any ideas please? Written in response to: XP and Excel (tony: Sunday, December 9, 2001 at 2:43 pm) Responses to this message: re: XP and Excel (tony: Monday, December 10, 2001 at 10:34 am) All messages in this thread [show all] XP and Excel (tony: Sun, Dec 9, 2001, 2:43 pm) re: XP and Excel (Hugh: Sun, Dec 9, 2001, 11:24 pm) re: XP and Excel (tony: Mon, Dec 10, 2001, 10:34 am) Reply or follow-up to this message Search this forum Start a new thread on a different subject Report abuse of the forum Return to the Windows XP Discussion Forum