I've typed a small table in Excel which contains a column of a dozen dates. The dates are typed in Australian fashion 10/11/03 (for today's date) and some of them are showing in American (11/10/03) for some reason. If you sort by date, it doesn't go into date order and if you check the formating, it says the language for that cell is now Armenian, or Chinese (Hong Kong) or Cyrillic or anything but English (Australian)! This is just so frustrating. I've looked everywhere, tried copying to a new document, reset the formatting, read the FAQs and checked support.microsoft but can't see anything that relates. Does anyone else know of anything that could help me?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel XP/Win 98SE - cell languages change
- Thread starter Valerian
- Start date
Similar threads
- Locked
- Question