How do I correct date format?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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.
Click to expand...

Any suggestions as to how to fix this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
cannot change date format 4
Copy Paste VBA formatting issues 3
date format convert 2
Max Value in Year 3
Date Conversion in Excel 2007 4
Formula to fill cells based on Date of Arrival and Date of Departure 1
How to enter start and end date/time in excel based on some specific value. 7

Back
Top