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

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

Thanks for the info, the results are better but not exactly what I want.
The cell now has a "1" in it without the dollar sign. I would like to keep
the dollar sign. I also noticed that the cell is left justified, so it
seems it isn't stored as a number, but a character.

H

"Bob Phillips" wrote in message
...
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