Annoyances.org
Home » Windows XP Discussion Forum » Message 1007937813 Search | Help | Home
  
Tip: Run a free scan for common Windows errors ad

XP and Excel
Sunday, December 9, 2001 at 2:43 pm
Windows XP Annoyances Discussion Forum
Posted by tony (2 messages posted)


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?


Responses to this message:
*re: XP and Excel (Hugh: Sunday, December 9, 2001 at 11:24 pm)

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)
Return to the Windows XP Discussion Forum


All content at Annoyances.org is Copyright © 1995-2008 Creative Elementtm All rights reserved.
Please do not plagiarize; redistributing these pages without permission is strictly prohibited.