Forum Discussion
Microsoft excel date format-not changing at all
I download an excel file(.xls) format from a particular portal that has been designed by the IT developers in my company. the downloaded excel sheet displays a date format which cannot be changed at ...
The values are text indeed. You can convert each of the columns to 'real' dates as follows:
- Select a column with dates, e.g. A2:A158.
- On the Data tab of the ribbon, click 'Text to Columns'.
- Click 'Next >' then 'Next >' again.
- In Step 3, select YMD from the Date dropdown.
- Click Finish.
You should now be able to compare the dates.
I tried that, but it's the dates are not matching.. HansVogelaar