Change the format of a date

Dell / LATITUDE E6400
May 7, 2010 at 00:40:19
Specs: Microsoft Windows 7 Enterprise, 2.668 GHz / 4083 MB
Hi,

I have a huge excel file where tha A-column is
filled with dates in the format dd-mm-yy tt:mm
and I really need to get this in european
standard yy-mm-dd tt:mm. I have tried to
change the format but without success. Could
anyone guide me? Please...


See More: Change the format of a date

Report •

#1
May 7, 2010 at 01:07:45
You don't say which version you have, my 2007 version has a date format option for yyyy,mm,dd 4 digits for the year as opposed to your 2.
Choose format, date, then scroll down the arrow alongside, it's almost at the bottom of the list.

Report •

#2
May 7, 2010 at 01:13:49
Thx for the quick responce...

I do have Excel 2007, sorry for that misstake. Changeing the
cell format does not affect the cell in anyway... strange but
that is the way it is. From the start the cell A1 looked like
this:

DATUM: 26/01/2010 TID: 01:15

I changed this with find & replace to become:

26-01-2010 01:15

What I need is:

2010-01-26 01:15

I have tried changeing properties with no effect what so ever...
I'm out of ideas...


Report •

#3
May 7, 2010 at 14:58:59
Excel questions are best asked in the Office Software forum,
that being said, sounds like your date was entered as TEXT,

To check this, select the cell with the date and format as GENERAL.

If it is a real date, you should get the number:

40204.05208

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 10, 2010 at 23:25:34
Thx for all the suggestions even though noone helpt. I have
now solved the problem by saveing it as a space delimited file
and then imported it to excel configuring the cells as date and
time as wanted. This solved everything...

Mike: Thank you for pointing out where to enter this type of
questions. I acctually thougt I did put it in there. This was my
first post and I had no Idea how It worked.

//Ernesto


Report •

Ask Question