Date format not changing

[Johnatha]

Hello!

I have several columns with the dates in them. I'm looking to create a VB code that searches certain ranges where the dates are located (example, Range("A1:A50") and convert them properly to the following NumberFormat("yyyy,mm,dd"). The problem is that my "Date" cells look like this "24.04.2006". Those periods seem to make the cell unable to convert properly to a "Date" format. Does anyone know how I can achieve this, given that ALL my date cells have decimal places?

Thanks!

[TMS]

Select the range of dates. Choose Text to Columns from the Data Ribbon. Delimited | delimiters not important | Column data format: Date: DMY | Press Finish

Done


Regards, TMS

[AB33]

A period(Dot) 24.04.2006 is a text in excel. you need to replace them with either / or - in the hope excel will read them as dates.

[Johnatha]

PERFECT! Thanks TMS, worked!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.