Formatting errors w/ imported dates

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

Using Excel 2000 SP3

When importing data from Crystal Reports into Excel, our
staff noticed problems sorting by date in Excel.

We determined that Excel was not recognizing the field as
a date, so we went into Cell Formatting and selected the
date format that we wanted. This still did not sort
correctly by date.

The only way we have been able to get it to convert to the
proper date format is to double-click the date fields cell
by cell which is unreasonable for 20,000 lines of data.

Does anyone know of a fix for this issue?

Thank you! Your help is appreciated.
 
Select Whole Column - Do Data / Text To Columns / Delimited, Hit Next - (only
Tab will be selected and that's OK), Hit Next - Select Date Format and hit
Finish.
 
You must log in or register to reply here.

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

Remove date format? 3
Date Formatting 2
Sort imported date column 7
Which is the best MBOX Converter Tool different formats conversion? 4
Dates in Excel 2007 5
Change date from yyyymmdd to valid date format 4
Problem sorting by date after 2029 on Excel 2003 1
Date Format (No Time) 2

Back
Top