Hi Stevie,
You can change the format of cells by selecting FORMAT CELLS, then click
on DATE and select whatever format you would like them to have.

Regards,
Tom

"steviec334567" wrote:


Hi,

I am new to all this excel help forum.
Can you help me i have a column that is formatted as numbers but is
actually dates so 1st Jauary 2006 is stored as 112006, and the 24th
April 2004 is stored as 2442004 so if i sort on this column the 1st
January 2006 comes first but in reality the 24th Spril 2004 comes
first.

How do i get excel to store it as a date in the formatdd/mm/yyyy.

Please help


--
steviec334567
------------------------------------------------------------------------
steviec334567's Profile: http://www.excelforum.com/member.php...o&userid=33852
View this thread: http://www.excelforum.com/showthread...hreadid=545415