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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.