The cell doesn't identify the date in it unless typed again.

[resiexfor]

I've set the format of the column as "date" to be able to filter easily.
But it's forcing me to type each cell again so that it's identified as date.
The file is generated using company's program database, and i'm trying to filter it by date

https://ibb.co/cWobCG

http://uploads.im/bP6fx.jpg

Thanks for your help in advance

 

[mole999]

freeware / commercially available programme called ASAP utilities can change unrecognised numbers text to numbers. If you have a formula in the right column you are showing and if in col C you type =ISNUMBER(A1) and it comes back as false then you could use a double minutes. OK just prove the left column is too big to be a date

Excel Workbook
	A	B	C
1	7964675	7964675	FALSE
2	64675	25/01/2077
Sheet1

 

[MARK858]

Try selecting the column, Data tab, Text to Columns, click Next twice, check that the General checkbox is checked and click Finish.