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 ...
I am sending an excel sheet with only the date columns for the new and old data sheet. Basically I have to concatenate each of the cells and then match the final concatenated data using the "IF" statement. But since the date formats for both the sheets differ, so the end result is a mismatch. Please have look.. I was wondering if had something to do with the settings of my Windows Excel. HansVogelaar
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