Sorry All,

I am still having problems with this ridiculous date/text issue when exporting to Excel.

Using the =DATEVALUE function for myself triggers the #VALUE error.

A quick online search confirmed that for the function to work the export format needed to be as follows: 23 May 2022

Apparently exported dates in the format of 05/23/2022 are not valid for the function (such as mine are)...

As for using the Data Validation method; it seems so sporadic with the results, meaning, it converts a portion of the cells, then has no effect on others (no clue why it effects each cell differently - that's the only constant for me)

Shamefully, I am currently reduced to using four (yes four helper columns) as follows (Assumes Date is in A1 and helper columns are in B1-E1): 

B1: =Left(A1,2)

C1: =Mid(A1,4,2)

D1: =Right(A1,4)

E1: =Date(D1,B1,C1)

QBO please resolve this... It is not an Excel or Cache issue so far as anyone in this chat (myself included) can find...