I am creating a copy of Excel file using VBA. In the file, there is a column that contains numbers with the preceding zero. The file is copied, but the data is dropped in this column. I need to keep the values from the previous zero, how can I solve this problem with VBA?
Convert each cell to the first text field in that column Exporting it should ensure that each The character was retained (and not behaved like a number, which seems like it is happening).
Comments
Post a Comment