Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Convert yyyymmdd text to Date format
Thank you, your help is greatly appreciated :)- nirod
- Post #4
- Forum: Microsoft: Office
-
Excel Convert yyyymmdd text to Date format
Importing text into Excel sets the yyyymmdd field as text format. Program will not convert this field to DATE format. Get ######. Cannot find help in Excel on this matter. Can anyone tell me how to convert 20060701 to 07/01/2006?- nirod
- Thread
- Replies: 5
- Forum: Microsoft: Office
