How do you change the data type of a cell using VBA?
 

For instance, with VBA I am trying to place "February 2007" in a cell
but it keeps showing up as Feb-07. I want it to show up as literal
text.




--
justme0010

How do you change the data type of a cell using VBA?
 

Sub text_it()
Range("A1").Value = Chr(39) & "February 2007"
End Sub

--
Gary''s Student - gsnu2007c

How do you change the data type of a cell using VBA?
 

You could keep the value a date and just format the cell the way you like:

with activecell
.numberformat = "mmmm yyyy"
.value = dateserial(2007,2,1)
end with

You could also format the cell as text first:

with activecell
.numberformat = "@" 'text
.value = "February 2007"
end with

or this variation of Gary's Student's response:

with activecell
.numberformat = "General"
.value = "'February 2007"
end with



justme0010 wrote:

For instance, with VBA I am trying to place "February 2007" in a cell
but it keeps showing up as Feb-07. I want it to show up as literal
text.

--
justme0010

--

Dave Peterson