How do I correct date format?

's Computer Specifications

Just downloaded bank statement in .csv format.

When I load it into Excel the date column contains a number, 7011.
When I try to convert this to something more meaningful, Format > Cell
> Date and select my prefered format it comes back as 12/03/1919, when it should be 20/05/2006.

Any suggestions as to how to fix this?

's Computer Specifications

Ooops!

Operator error please ignore earlier posting.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Correct date format	John	Microsoft Access	2	9th Apr 2008 06:37 PM
Correct date format	John	Microsoft Access Queries	2	9th Apr 2008 06:37 PM
date format not correct	=?Utf-8?B?U2llbWVsIE5hcmFu?=	Microsoft Excel Misc	3	15th Jun 2007 11:22 PM
Track change Author/Date popup shows US date format not correct regional set	Wayne Zaunders	Microsoft Word New Users	1	23rd May 2004 11:57 AM
date format not correct		Microsoft Excel Setup	0	13th Nov 2003 02:22 AM