INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...This site is awesome!...Things I have been trying to figure out for weeks, I got the answer in hours!..."
Geography
Where in the world do Tek-Tips members come from?
|
 Excel Convert yyyymmdd text to Date format
|
|
|
nirod (TechnicalUser) |
26 Jul 06 11:00 |
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? |
|
In a column to the right of the imported data, use this formula: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))Copy the formula down as far as needed. (Replace A1 with the appropriate cell reference) _____
-John
The plural of anecdote is not data
Help us help you. Please read FAQ181-2886 before posting. |
|
FYI... Why do Dates and Times seem to be so much trouble? FAQ68-5827 Skip,
 |
|
|
nirod (TechnicalUser) |
26 Jul 06 12:18 |
Thank you, your help is greatly appreciated :) |
|
Glad you got it sorted out.  _____
-John
The plural of anecdote is not data
Help us help you. Please read FAQ181-2886 before posting. |
|
You can also just select the data and use Data / Text To Columns on it, then just specify DATE and choose the YMD option. No extra formulas and data sorted in situ. Regards Ken............. ----------------------------------------------------------------------------
 It's easier to beg forgiveness than ask permission
---------------------------------------------------------------------------- |
|
|
 |
|
