VBA date format

[vbanewbie68]

Hi

Can anyone help me on this please?

Please see my screenshot. How to change this: 2021-11-09T15:00:57 UTC into dd/mm/yyyyy format in VBA?

Thank you in advance

Best

V

 

[Dan_W]

Well done for solving it yourself - sorry, I was having dinner.
Did you work out why it wasn't working? (I think I know). Also, do you understand why the C2 data came out differently?

 

[vbanewbie68]

Well done for solving it yourself - sorry, I was having dinner.
Did you work out why it wasn't working? (I think I know). Also, do you understand why the C2 data came out differently?

I accidently added a new column and that is why it states overflow.

 

[Dan_W]

Unlikely.
So the reason it came up with an overflow is because it was trying to run the operations in the code I provided to you against cells C2:C6 in an entirely different sheet to the one you had intended to. This is why I had asked you for the name of the sheet. This way, we could properly qualify the cell reference not only to Range("C2:C6") but to, say, Sheets("MAIN").Range("C2:C6").

 

[vbanewbie68]

I see. Thanks for this. It makes sense to me now. That is so kind of you to help me all this to understand better.
Best regards
V

 

[vbanewbie68]

Hi again

There is one more thing I like to add on this matter in relation date format? Would that be okay to reply you on this please?

Best regards

V

 

[Dan_W]

Sure. I assume you meant to ask here - it's best that others with similar issues/problems be able to benefit for seeing a working solution.