Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Rosa
How did you combine the month and year? Did you Concatenate them? Sounds like these are now treated as text. Try DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish. Gord Dibben Excel MVP On Mon, 12 Sep 2005 14:16:02 -0700, "Rosa Campos" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
Date Format when incoming date can be 0 | Excel Discussion (Misc queries) | |||
Date format | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |