Not Date Formats Converting

[reberryjr]

Any idea why this code isn't converting all dates in the ranges to MM/DD/YY? It does change some of the dates, but not all. The ones that aren't being changed show values like 07/17/2023 in the formula bar. If I double click in a cell that wasn't converted, the date magically converts.

'Format columns as MM/DD/YY.
mD.Range("G2:G" & mDLR).NumberFormat = "MM/DD/YY"
mD.Range("K2:K" & mDLR).NumberFormat = "MM/DD/YY"
mD.Range("M2:M" & mDLR).NumberFormat = "MM/DD/YY"

 

[Joe4]

Date formats only work on numbers/values entered as valid dates.
It does NOT work on values that were entered as Text (formatting does not apply to any Text entries).

If you re-enter it, it usually converts it to a date which can be formatted (provided it is a valid date value, and not something like 02/32/2023).
You can re-enter/convert a whole column at a time by selecting the column, going to "Text to Columns" from the Data menu, going to the third step, and select the Date option with the MDY format, and clicking finish.
You will have to do each column individually, as you cannot do Text to Columns on more than one range at a time.

 

[reberryjr]

Date formats only work on numbers/values entered as valid dates.
It does NOT work on values that were entered as Text (formatting does not apply to any Text entries).

If you re-enter it, it usually converts it to a date which can be formatted (provided it is a valid date value, and not something like 02/32/2023).
You can re-enter/convert a whole column at a time by selecting the column, going to "Text to Columns" from the Data menu, going to the third step, and select the Date option with the MDY format, and clicking finish.
You will have to do each column individually, as you cannot do Text to Columns on more than one range at a time.

Didn't even think about the data coming over as text. Thanks @Joe4

 

[Joe4]

You are welcome.
That is usually the dead give-away. Formatting has no impact on text entries.
Also, if you notice that the dates (or numbers) are left-justified in a cell instead of right-justified, that is also another indication you are working with text entries.