VBA concat code returning 41348 for date instead of 3/15/2013

[Bevg]

Hi everyone,

Need another set of eyes to see what the problem is.

The code is suppose to concatenate column C if column B =Company with row 2 and row 3 column C. Here is the code

Please Login or Register  to view this content.

And attached is the result. I need it to concatenate the company and the date and row 3 col C even if blank.

I would really appreciate any help I can get on this.

Thank you

Bev

[TMS]

Have you tried formatting the cell as a Date?


Regards, TMS

[Leith Ross]

Hello Bevg,

Try this macro and let me know if it needs adjusting.

Please Login or Register  to view this content.

[Bevg]

[QUOTE=TMS;3679970]Have you tried formatting the cell as a Date?


Yes, I did format and nothing happened.

[TMS]

Please Login or Register  to view this content.

The important bit of code is just this:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Just looked again. Maybe this is more what you wanted:

Please Login or Register  to view this content.

Regards, TMS

[Bevg]

THIS DID IT!!! Thank you so much for your help! I can see now where the problem was and how the suggestion did the trick. YOU ROCK!!!!

Bev

[TMS]

You're welcome.


Note: you have added "Solved" to the post title. This does not mark the thread as solved.



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.

[Bevg]

Thanks again for the instruction to "add SOLVED" to my post.