Cell format as "Text"

's Computer Specifications

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.

's Computer Specifications

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.
>
>
>

's Computer Specifications

Thanks

"Gary''s Student" <(E-Mail Removed)> wrote in message
news:0F1E5D63-1474-4842-909D-(E-Mail Removed)...
> 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.
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I have to double click a cell for the "text" format to take	=?Utf-8?B?Q2hhcmxlcw==?=	Microsoft Excel Misc	2	24th Jan 2006 02:46 PM
How to change default cell format to "Text"	rbecerra	Microsoft Excel Misc	2	10th Sep 2005 04:29 AM
How do I set Excel cell format to "Text" from VB.NET?	=?Utf-8?B?Lk5ldA==?=	Microsoft Excel Programming	3	3rd Aug 2005 03:48 PM
How do I set Excel cell format to "Text" from VB.NET?	John Brock	Microsoft Excel Misc	8	26th Jul 2005 04:36 AM
Format "only" dates withing text in a cell.	dave	Microsoft Excel Misc	3	5th Dec 2003 01:24 AM