Text to columns

[efernandes67]

Hi,

See attached file.

I have in column A a set of dates with the format from "Microsoft Project" file. Some of these dates come with date ant time, but I only need the date.

If I use the menus, "Text to columns" to convert, setting only 'comma:=True', everything works ok and I get the result I need in column D.

I generated a macro and the code is this:

Please Login or Register  to view this content.

When I run the macro the result shown in column H is different from when it is done from the menus! Why?

What can I do to get the result I need using a macro?


Regards,
Elio Fernandes

[Norie]

Elio

What happens if you run this code?

Please Login or Register  to view this content.

[efernandes67]

Norie,

I get the result of the cell A2 "41225,375". I didn't understand the reason ofyour question. Do you have anything in mind?

Because my excel settings maybe differents than yours, I attached an image so that you can see the values.exf_Text_To Columns_picture.JPG

[Norie]

I was trying to see if somehow VBA was using different separators than you are.

Doesn't look like it though.

Why not try a different method to get the date?

For example you could use the INT worksheet function.

That will extract the integer part of the date/time, which is the date.

[efernandes67]

Hi Norie,

I tried to use the INT function but I did not ge the results I needed so I tried the TRUNK function and it is working.

Thanks,
Elio Fernandes