Convert Textstring Date to Value Date - Appreciate your help!

[Xceller]

Hi - I have some text dates like: 8/19 ; 8/16; 8/6 in 2 columns. I want convert them to 08/19/13; 08/16/13; 08/06/13.
The problem I have after converting them is that they are all text dates. I tried Datevalue(xxxx), but it doesn't work.
Below is my code:

Please Login or Register  to view this content.

[Leith Ross]

Hello Xceller,

Let VBA do the conversion for you by declaring a variable as Date Type.

Please Login or Register  to view this content.

[fredlo2010]

Hello Xceller,

Let VBA do the conversion for you by declaring a variable as Date Type.

Very nice Leith

[Xceller]

Hi Leith Ross - Appreciate your looking into this. It is very stubborn. They still show as text dates after running your code. I attached a small sample of the workbook. Can you take a look.

[Leith Ross]

Hello Xceller,

The macro worked for me. I too am using Office 2010. Here is variation that might do it. Setting the cell's formula property, instead of the value, should force the cell format from text to a date.

Please Login or Register  to view this content.