the date format is not working ,sort by date doesn't work.

I have this Excel spreadsheet, I took the year from one column, and the month
from another column and put it in one column together, it looks like AUG
1989, but when i try to sort by Date it doesn't. I'm sure the format is
incorrect.

Rosa

How did you combine the month and year?

Did you Concatenate them?

Sounds like these are now treated as text.

Try Data>Text to Columns>Next>Next>Column Data Format>Date>MDY and Finish.


Gord Dibben Excel MVP

On Mon, 12 Sep 2005 14:16:02 -0700, "Rosa Campos"
<RosaCampos@discussions.microsoft.com> wrote:

>I have this Excel spreadsheet, I took the year from one column, and the month
>from another column and put it in one column together, it looks like AUG
>1989, but when i try to sort by Date it doesn't. I'm sure the format is
>incorrect.