When you say that when you load the array the value looks like 00030, are you
loading an integer formatted to show leading zeros or are you loading a
string? Also when you say that you check later on are you outputting the data
to a cell where implicit conversion may be happening or are you placing a
watch on the variable and checking it's contents? Another question is you say
that it is an array of strings. Is it declared as an array of strings or is
it declared as variant? Is it ever passed to a sub where the argument is
declared either as variant (or not declared which is implicitly variant)?
--
HTH...

Jim Thomlinson


"quartz" wrote:

When I copy cell contents that looks like "00030" into a string array, then
later check the array contents it looks like: "30". I need to keep the
leading zeros in the variable. Anyone have a quick and easy way to do this?