re: XP and Excel Monday, December 10, 2001 at 10:34 am Windows XP Annoyances Discussion Forum Posted by tony (2 messages posted) Thanks, but the problem is the way in which Excel interprets the value I enter into the formula bar. In the UK, 6/01/01 means 6 Jan 2001, not 1 June 2001 On Sunday, December 9, 2001 at 11:24 pm, Hugh wrote: >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: re: XP and Excel (Hugh: Sunday, December 9, 2001 at 11:24 pm) There are presently no replies to this message. 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