mgmhicks
asked on
string "0E302" turns into 0.00E+00 when copied to another cell
I have a string array with shows "0E302" as the value. However when I do a Sheets
Here is the code to get the information into the array
they all seem to be strings at this point. Anyone have any ideas.
thanks
("MergeRecords").Cells(n, 3) = CStr(myArray(2))
it ends up on the other sheet as 0.00E+00.Here is the code to get the information into the array
myArray = Split(ResidentID, "-")
they all seem to be strings at this point. Anyone have any ideas.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER