Can't get dates to format corrrectly.

[Guest]

Hi,

I ran a MS-Access query to pull in some data from our database and one of
the date fields has the data formatted as either MM/DD/YYYY or YYYY-MM-DD. I
want to change the data on the Excel sheet so that all rows display this date
as MM/DD/YYYY.

I tried to obvious of selecting the entire column and setting the format to
just that date format but still those dates remain formatted as YYYY-MM-DD.
When the data came into Excel it was set to a general format for that
particular column.

Any ideas on how I can accomplish this?

 

[KC Rippstein]

You might try this: go to any blank cell off to the side and copy it, then
highlight the dates you are struggling with and Paste Special -> Add. If
your dates imported as text, this will convert them back to numeric and you
can then format the column.
- KC