Excel date format

5 pts.
Tags:
Database migration
Excel 2003
Excel 2003 functions
Excel Database
I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

Software/Hardware used:
Excel 2003
ASKED: September 21, 2010  1:15 PM
UPDATED: September 22, 2010  6:16 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Excel Help says you can use a function called DATEVALUE. In an empty cell, type =DATEVALUE( then click the cell that has the Text date and then close the parenthesis and press ENTER. That gives you the serial number of the date, and you can use format to cause it to to look like the date format you want.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DoneThat
    I had a long winded answer and fortunately forgot to sign on so it didn't post. Then I saw Tlsanders1 reply. Son of a gun - I tested it and works like a charm. Another tool in the box! Thanks tl
    830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following