VB Code:
  1. NumberFormat = "@"
is what you should use to mark a cell as TExt.