Selectively prevent excel from changing cell format to number from VBA

I am importing records into excel by iterating through the field names and values and inserting into a table. Fields are strings, numbers, and dates. The problem is that I have a list of values that are comma separated and I want to insert them into a table as a string but excel keeps converting the cell to number, removing all the commas, and turning the string into one very large number. How can I prevent excel from doing this without affecting other cell formatting for fields that need to be number or date?

Thanks, I ended up just created a routine to replace the commas with semicolons before copying into the sheet