What is the property and syntax to format a cell as text

E

Eggle

With ActiveCell
.Offset(, 3).NumberFormat = "Text"
this fails - runtime error 1004, unable to set NumberFormat

.Offset(, 3).NumberFormat = "General"
works OK

What is the property/syntax to format a cell as text?
 
P

Paul B

Eggle, try, .Offset(, 3).NumberFormat = "@"
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

Dave Peterson

Paul gave you the answer, but these are the kinds of things that you can find
out quickly by recording a macro when you do it.

It's another thing that you don't have to remember, since excel can tell you in
just a minute or two.
 
Top