You ask about a reliable way to make the problem disappear. In the actual question, you had in essence answered that question by saying formatting that cell as text helped. You have already set the range, now select it and use something like Selection.NumberFormat = "@" to convert enmass to text.