I currently have a central dataset workbook which opens a range of other workbooks, copies values and then pastes them in the Master workbook.
When VBA stores a variable (as STRING) that looks like a number, it then Pastes the string as a number. I would like it to paste as TEXT.
Please help! Relevant code is below