Home > IT Answers > Database > Excel date format
Tamara
5 pts.
 Excel date format
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
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  September 22, 2010  5:39 pm  by  tlsanders1   1,240 pts.
All Answer Wiki Contributors:  tlsanders1   1,240 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

DoneThat
 830 pts.