I have an array that contains several items.
Some are pure text, some are numbers as text, and some are numbers.

I assign the array to a range using:

Set myRange = Range(.......
myRange.Select
myRange = myArray

However, when I do this the items that are numbers as text are
converted back to numbers. I don't want this as its important they be
numbers as text because our ERP system understands those to be things
like division, department, location, etc. identifiers and numbers and
numbers to be $ or people. How can I keep VB from converting them to
numbers during the assignement?