Formatting cell for text
 

I have a text field on my sheet that takes data in as "$100K" or "$75K" or
"$1".

The first two field are stored correctly in the column, but the third one is
stored as 1 and is left justified

I formatted the cells as

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



How can I make sure the dollar sign is kept in that field.



Thanks