Date Format

[gymwrecker]

I have a column with over 5K date entries in the following date format: 01/01/2014. I noticed they were originally formatted as "General", so I right clicked and tried to change their format to "Date Format" YYYY/MM/DD and nothing changed. "Text to columns" didn't do anything either. I'm trying to get these dates in the right format in order to sort by year. Any help is greatly appreciated it.

 

[Fluff]

You need to select MDY as that is the format the data is in.

 

[SanjayGMusafir]

Share XL2BB of real data to understand the real problem behind

 

[Fluff]

When you did text to columns what date format did you select?

 

[gymwrecker]

When you did text to columns what date format did you select?

YMD

 

[gymwrecker]

You need to select MDY as that is the format the data is in.

You need to select MDY as that is the format the data is in.

Got it! OMG, something so simple! Thank you Fluff!!!

 

[Fluff]

You're welcome & thanks for the feedback.