a cell is dim as social security. I want to copy that to a variable.
What do I dim the variable as?

If I use string, then when I copy it to a different cell dim as social
security it shows up as #######.

If I use some number like integer or double it doesn't get the whole number.

Thanks

john