Range(currRow, currColumn).NumberFormat = "@"

--
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Henry Jones" wrote in message
...

I want to have "$1" appear in the cell. This is how I formatted the cell

.Range(currRow, currColumn).NumberFormat = "Text"

.Range(currRow, currColumn).Value = "$1"



When I view the contents of the cell it shows

T1900xt



What is going on? How can I get "$1" to appear in the cell





Thanks