Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change chart type in single data series, Excel 2007 | Charts and Charting in Excel | |||
Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
How do I type in colour without having to change it every cell | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
Change Excel cell format date type examples ("14-Mar-01") | Setting up and Configuration of Excel |