Date Format / Pivot Table Grouping

[s boak]

Hi Folks:

I've imported 4,000+ records from a Filemaker database.

About 70% of the dates come in formatted as mo/da/yr and are right justifed
About 30% come in as yr/mo/da and are left justifed
Setting up a pivot table, I'm not able to do a year group (I guess becasue
of the dating)
I'm not able to change the format of the 30%

Is there a way to change yr/mo/da to mo/da/yr - or any other suggestions ??

Many thanks
Steve

 

[Debra Dalgleish]

Sort the dates and the yr/mo/da entries should be grouped at the bottom
of the list.
Select the yr/mo/da entries
Choose Data>Text to Columns
Click Next, Next
In step 3, under 'Column Data Format', choose YMD from the Date dropdown
Click Finish

 

[s boak]

Debra:
Thanks so much - works like a charm

Sort the dates and the yr/mo/da entries should be grouped at the bottom
of the list.
Select the yr/mo/da entries
Choose Data>Text to Columns
Click Next, Next
In step 3, under 'Column Data Format', choose YMD from the Date dropdown
Click Finish

??