As part of a VBA Sub I need to assign an array to the sheet.
The array is declared like this:
Public testArray()

Sometimes this array holds the text:
7E043

Now the trouble is to avoid this being displayed in the sheet as 7.00E+43

Even when I apply the text format to the sheet (by doing range.NumberFormat
= "@") before
assigning the array it still happens.

One solution is to put single quotes before the text, but that has some
drawbacks.
The other solution is to declare the array as string, but that has even more
drawbacks.

What would be the solution to this?
Thanks for any advice.


RBS