I am working on a process that involved a data transfer from one excel to other based on some conditions. From one of the column in source excel has data like 8768/0001, 3423/0001, etc. I mean some data that ends with “/0001”.
So the issue that I am facing right no is when I write this specific col back to my new excel, it takes this data in numerical value and writes it back as 8768,3423 and so on.
There are some vLookup formulas linked to the new excel that gives back “#N/A” as a result.
What I am thinking is to change the data type of that column to Text but I don’t know how to achieve this.
Need some ideas on this.
Thanks and Regards