I'm pulling my hair out.
I developed and excel app with a user form and pages of VBA. I use a web query to update excel. Serial numbers are listed in one column within the report and excel cell. When the web query updates excel and there is more than one serial number per cell, say 24356,7665,6,7788,89..I get: 9.00385190038529E+167 as a result.
Can I change the delimiter for serials in a report?
or
Can I join a character to my serial column and strip it out in excel?
or
Is their any way to list the serials line by line? I can do this in a SS but not reports.
Support says not possible. However, they also said splitting serials on a SS was not possible...and they were wrong.