Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
I am programmatically (via C#) placing data on an Excel spreadsheet. Problem
is that some of the data look like dates (e.g "4/22") which really are not dates. Excel is automatically converting these to dates. When using Excel, I can set the cell's format category to "Text" and it will display properly. How do I do that programatically? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
Julie wrote:
I am programmatically (via C#) placing data on an Excel spreadsheet. Problem is that some of the data look like dates (e.g "4/22") which really are not dates. Excel is automatically converting these to dates. When using Excel, I can set the cell's format category to "Text" and it will display properly. How do I do that programatically? add "'" at the beginning of your text. var = "'" + var and now Excel will see it as text. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
Thanks for your help... but I need a way without altering the data values (via some kind of number formatting). For example, I tried myRange.NumberFormat = ""; or myRange.NumberFormat = "Text"; which didn't work. But I'm looking for a solution more along those lines. Thanks a bunch! "witek" wrote: Julie wrote: I am programmatically (via C#) placing data on an Excel spreadsheet. Problem is that some of the data look like dates (e.g "4/22") which really are not dates. Excel is automatically converting these to dates. When using Excel, I can set the cell's format category to "Text" and it will display properly. How do I do that programatically? add "'" at the beginning of your text. var = "'" + var and now Excel will see it as text. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
myRange.NumberFormat = "@"
Charles Chickering Julie wrote: Thanks for your help... but I need a way without altering the data values (via some kind of number formatting). For example, I tried myRange.NumberFormat = ""; or myRange.NumberFormat = "Text"; which didn't work. But I'm looking for a solution more along those lines. Thanks a bunch! "witek" wrote: Julie wrote: I am programmatically (via C#) placing data on an Excel spreadsheet. Problem is that some of the data look like dates (e.g "4/22") which really are not dates. Excel is automatically converting these to dates. When using Excel, I can set the cell's format category to "Text" and it will display properly. How do I do that programatically? add "'" at the beginning of your text. var = "'" + var and now Excel will see it as text. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
myRange.numberformat = "@"
Sometimes you can get the answer by recording a macro within excel. Julie wrote: Thanks for your help... but I need a way without altering the data values (via some kind of number formatting). For example, I tried myRange.NumberFormat = ""; or myRange.NumberFormat = "Text"; which didn't work. But I'm looking for a solution more along those lines. Thanks a bunch! "witek" wrote: Julie wrote: I am programmatically (via C#) placing data on an Excel spreadsheet. Problem is that some of the data look like dates (e.g "4/22") which really are not dates. Excel is automatically converting these to dates. When using Excel, I can set the cell's format category to "Text" and it will display properly. How do I do that programatically? add "'" at the beginning of your text. var = "'" + var and now Excel will see it as text. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
Worked perfectly. Thanks much!!! :-)
"Die_Another_Day" wrote: myRange.NumberFormat = "@" Charles Chickering |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
The "@" symbol worked. Thanks.
I don't understand what you mean by "recording a macro within excel". I really haven't done any macros in Excel, nor any VBA. I've only programmed in ..NET C#, using Visual Studio Tools For Office. "Dave Peterson" wrote: myRange.numberformat = "@" Sometimes you can get the answer by recording a macro within excel. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force a cell to display as Text
1. Open excel, go to tools/Macro/Record new Macro.
2. Do, what you want to do with Excel, i.e. change cell formating to text. 3. Go to tools/Macro/Stop recording 4. Click Alt-F11 to open VB Editor 5. Find your project and usualy Module1 module. 6. Look at the code generated by macro recorder. you will find: Sub Macro1() Selection.NumberFormat = "@" End Sub Now, you know how people know what to put as number format. :) Julie wrote: The "@" symbol worked. Thanks. I don't understand what you mean by "recording a macro within excel". I really haven't done any macros in Excel, nor any VBA. I've only programmed in .NET C#, using Visual Studio Tools For Office. "Dave Peterson" wrote: myRange.numberformat = "@" Sometimes you can get the answer by recording a macro within excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force a wrap text function when the cell is big enough to p | Excel Discussion (Misc queries) | |||
How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) | |||
How to force userform to display everything? | Excel Programming | |||
Macro to force text to rol to next cell | Excel Programming | |||
force text in a cell based on value of cell in a range | Excel Programming |