Excel not recognizing date in date format

[outlawspeeder]

I am pulling information in from a web site and I have a column with what looks like a date but is not recognized as a date by Excel. I have tried on the Excel copy and paste as …. The dates are left handed justified. If I click into the cell and do a hard return it moves to the right justification and it is now a date.

If I record this as a Macro it shows me entering that date from the cell.


Looking for a VBA solution or guidance

Thanks

 

[ChrisFoster]

Are you UK or US based? Or other?

 

[sandy666]

maybe try Data - Text to Columns, choose proper Date format in 3rd step

 

[outlawspeeder]

US

 

[Rick Rothstein]

Are you UK or US based? Or other?

I have found in the past when a date (or number) looks correct but is left justified, simply selecting the column and clicking the Finish button as soon as the Text To Columns dialog box appears is sufficient to "correct" the entries.

 

[ChrisFoster]

Presuming your date is in column A, try;

Sub Macro()

Range("A:A").NumberFormat = "mm/dd/yyyy" 

End Sub

 

[outlawspeeder]

Chris and Rick
both work
Data to text I recorded into a Macro for each
and
Number format I did a loop.


Thank you for the help