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