unable to change date format on imported data

G

Guest

I import a comma delimietd text file into and existing spreadsheet that
contains two columns originally defined the General data format. During the
import process I am allowed to change the data format to Data MDY. Yet, when
the file is imported the two date fields appear as General in Year Month Day
format.


The original data is in this format: 20060627.
I change the format to Date MDY and expect 06/27/2006
I get 20060627
 
G

Gord Dibben

When in the text import wizard, select column data format>date and select YMD
from the options then Finish.

Format as you wish after you have converted to a date.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imported data Date Format 4
Remove date format? 3
Data to Date conversion with multiple formats 1
date format 1
Cell Format on Imported Data 3
Change date from yyyymmdd to valid date format 4
Date conversion on text file import 5
Change General format to Date format 2

Top