Date Formatt not detected as date by excel

Do you need the time part?

Try this.

• In column C type this formula. =INT(B2) That extracts the date portions.
• fill / copy down if the Table doesn't do that automatically.
• just for insurance purposes (never throw away good data) extract the time in column D with this formula =MOD(B2,1)
• you will need to reformat that for time.
• Now copy both those columns and paste values back onto themselves.
• Select the dates in column C and drag them over to column B replacing those.
• You can of course skip the step extracting the times.

Did this help?

meus, forum rules require you to wait at least a day before bumping your thread

Having said that, 1 way to "fix" this...
1. highlight the entire range
2. click Data tab/Text2Columns
3. click Next/Next/check Date and pick a format
4. click Finished

meus

We receive this report from you.

No one has the solution.... No expert can solve these simple problem????
whats the use of this forum then?

1) The report post button is only if someone want's to report any violation of any forum rule and NOT for questions or complains!

2) As you don't know the solution what's make you to believe that the(your) problem is simple?

3) The members of this forum are ALL here VOLUNTARILY and of course they reply to threads if they have free time and of course if they want to do this. No one is(will) be able to force them to reply.

Pls be patient.

The Commercial subforum could be also a solution for you.