Posted to microsoft.public.excel.misc

Dickery1

external usenet poster

Posts: 1

DATE SORTING excel

Hello
I use the canadian office 2003. My dates are messed up. even though i
tried to format it in date format, it uses different seperators to as
delimitors. how do i fix it.
10/05/2007
06/07/2007
02/09/2007
07/12/2007
01-14-2000
01-15-1991
01-15-2003
01-15-2008
01-22-1998
01-25-2005
01-26-1998
01-27-2005
01-27-2006
01-29-1993
01-31-1994

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date sorting	rcc	Excel Discussion (Misc queries)	4	May 10th 10 10:47 PM
sorting by date in excel	pattyf	Excel Discussion (Misc queries)	4	February 14th 08 08:18 PM
Sorting by Date, And SUM	Zee	Excel Discussion (Misc queries)	1	July 31st 06 12:30 PM
Sorting by date	[email protected]	Excel Discussion (Misc queries)	7	June 17th 06 01:06 PM
Sorting by date when the date isn't exact	Kim	Excel Discussion (Misc queries)	1	May 5th 05 10:44 PM

All times are GMT +1. The time now is 08:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us