(Solved) – How to convert column Year as YYYY in VBA

  • by

I have a column Year in my excel sheet in the format YYYY and initially it is of type Text. I am trying to change the column format to Year but the value is getting modified after formatting.
I am doing this to export the column into my database which is of type Year. Is there a vba code that returns this text field as YYYY?

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *