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

resiexfor

New Member
Joined
Jan 6, 2018
Messages
3
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
Microsoft_Excel_Oct_2017_xls_Compatibility_Mode_2018_01_06_09_50_56.jpg



https://ibb.co/cWobCG

http://uploads.im/bP6fx.jpg

Thanks for your help in advance
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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
ABC
179646757964675FALSE
26467525/01/2077
Sheet1
 
Upvote 0
Try selecting the column, Data tab, Text to Columns, click Next twice, check that the General checkbox is checked and click Finish.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top