| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format as "Text"
I don't working with the excel object model that much, so...
What is the property that should be set to make a cell of type "Text" instead of "General", etc. ..NumberFormat="Text"; throws an error. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell format as "Text"
Selection.NumberFormat = "@"
-- Gary's Student "EradicusMax" wrote: I don't working with the excel object model that much, so... What is the property that should be set to make a cell of type "Text" instead of "General", etc. ..NumberFormat="Text"; throws an error. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell format as "Text"
Thanks
"Gary''s Student" wrote in message ... Selection.NumberFormat = "@" -- Gary's Student "EradicusMax" wrote: I don't working with the excel object model that much, so... What is the property that should be set to make a cell of type "Text" instead of "General", etc. ..NumberFormat="Text"; throws an error. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| I have to double click a cell for the "text" format to take | Excel Discussion (Misc queries) | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Programming | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Programming | |||
Linear Mode
