Sorting Different Format Dates - Microsoft Office Excel

london735 · 10.08.2009, 00:51

Hello!
I have the following list of dates take from different data sources that need to be sorted starting from the earliest to the most recent. The dates are in all kinds of formats and stored as text. I wonder if there is a way to transform these date types into a single unified date format and then sort them by a macro – or any other way?
Thank you!

Tirendus · 10.08.2009, 01:22

Hey. Try importing all of the different data types into different columns. I think it would be really hard to convert all those dates while they aren't systematical. Then make one simple macro for each column to convert them into one type. My advice, make the french format like 1998.12.01 so you could sort them from earliest to the most recent.

SAS888 · 10.08.2009, 05:59

See attachment. Start macro "ConvDates".
P.S. Now You may sort given any way.

london735 · 10.08.2009, 21:10

thank you for this wonderful macro!!!!! works greatly!)

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
zip format	Jelena	Помощь студентам	2	04.01.2009 18:26
Format()	eda	Microsoft Office Excel	6	28.08.2008 11:21
Ошибка 'No argument for format "%s"'??	Lencom	Общие вопросы Delphi	2	25.06.2008 13:16
Microsoft Tape Format	svennick	Свободное общение	0	20.05.2008 21:33
Format	malevich	Общие вопросы Delphi	5	31.12.2006 00:37

10.08.2009, 01:22	#2
Tirendus Форумчанин Регистрация: 20.03.2009 Сообщений: 272	Hey. Try importing all of the different data types into different columns. I think it would be really hard to convert all those dates while they aren't systematical. Then make one simple macro for each column to convert them into one type. My advice, make the french format like 1998.12.01 so you could sort them from earliest to the most recent.

10.08.2009, 21:10	#4
london735 Пользователь Регистрация: 20.06.2008 Сообщений: 45	thank you for this wonderful macro!!!!! works greatly!)