Very simple question I can't find the answer to. I am simply writing a long array to a group of cells:
itemArray is Dimmed as a String array. Some of the values unfortunately are either mixes of numbers and letters or just pure numbers. When I try to write it to the spreadsheet, it converts the ones that look like numbers to numbers. I tried the following to fix, and searched around but could not find an answer:
Still writing the items that are numbers as numbers. How can I force the array output to be text, whether its a mix of text and numbers or just numbers?
Thanks!
Code:
For i = 1 To UBound(itemArray)
Cells(i, 1).Value = itemArray(i)
Next
itemArray is Dimmed as a String array. Some of the values unfortunately are either mixes of numbers and letters or just pure numbers. When I try to write it to the spreadsheet, it converts the ones that look like numbers to numbers. I tried the following to fix, and searched around but could not find an answer:
Code:
For i = 1 To UBound(itemArray)
Cells(i, 1).Value = CStr(itemArray(i))
Next
Still writing the items that are numbers as numbers. How can I force the array output to be text, whether its a mix of text and numbers or just numbers?
Thanks!