Cell Data Type Change

Question

Good day :)

I wish you can help me to solve my problem.

I have an auto generated file from a system. This file includes a column with a date format cells, yet its format is general.

When I change the number format into date, no change happens to the cell type. It remains as it is.

On the other hand, when I click inside the cell and press enter, the type of data cell is changed automatically into a date type.

The sheet I am working with consisting of about 1,000 records, so it will be so hard to press enter 1,000 times.

Is there a way to change the data type into a date without pressing enter for each cell???

Best Regards,

Ibrahim Tag

Answer 1

Try the following:

• Select the column.
• On the Data tab of the ribbon, click Text to Columns.
• Select Delimited, then click Finish.