Dates Not Copying Correctly

[Justinian]

I am copying dates from an external database to Excel in column A. When I do, dates appear in the format of "mm/dd/yy" (so today shows as 01/28/24). If B2 = today's date and I run the IF statement that says =B2=A2, the return is FALSE even though both A2 and B2 have 01/28/24 in the cells. When I manually type 01/28/24 in A2, all of a sudden B2 returns TRUE.

Why is this happening and how can I fix without re-typing all the dates in column A?

 

[Justinian]

Was trying to avoid using macros as my client firewall blocks them. I will try it on home PC if this is only option to make the dates appear normal.

 

[MARK858]

As I stated Fluffs's method can be done easily manually with a selection and a few clicks.
I would only use it in a macro if it was part of a larger macro (and I use virtually the same method to convert a column of text numbers to real numbers in a report pulled off our system every 2 hours)

 

[Justinian]

Got it, thank you.

 

[MARK858]

You're welcome, happy we could help