I have created a macro that selects everything in a sheet starting on A4 downwards. I want to use Text to Columns, delimited (comma and space) to separate the data.
When I do it manually, it does not change the date into a date format but keeps it as text (ex. 05/29/21). However, when I run the macro I created through the manual process, it changes it to a date format. I do not want it in the date format. I also do not want it to be in text format either
How do I edit the VBA to prevent it from converting anything to a date format without converting it to text, but just keeping it as general?
Cross-posted: https://www.mrexcel.com/board/thread...lumns.1172499/
Please Login or Register to view this content.
Bookmarks