Date sort

nmilson · May 9th, 2002, 01:49 PM

Hello

We ran a report at work and the date came, mm/dd/yyyy. I have reformatted for a custom format, however it won't sort including the year unless I double click on each cell which moves the information to the right hand side. (right now it sorts mm/dd) I can't duplicate this unless I am using the original numbers (info) they sent me. Is there any way to fix this. (a special paste to reformat the dates they gave???)

Many thanks in advance,
norm

Mark W. · May 9th, 2002, 01:51 PM

Select your values, choose the Data | Text to Columns... menu command and press [ Finish ].

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 01:49 PM	#1
nmilson New Member Join Date: May 2002 Posts: 1	Hello We ran a report at work and the date came, mm/dd/yyyy. I have reformatted for a custom format, however it won't sort including the year unless I double click on each cell which moves the information to the right hand side. (right now it sorts mm/dd) I can't duplicate this unless I am using the original numbers (info) they sent me. Is there any way to fix this. (a special paste to reformat the dates they gave???) Many thanks in advance, norm

May 9th, 2002, 01:51 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Select your values, choose the Data \| Text to Columns... menu command and press [ Finish ].