I use excel tables with lots of other programs. However, when I use an excel
table with "text" felds which only contain numbers, these fields are
considered numbers (not text) by these other programs.

However, if the cells have little green triangles in them, these other
programs consider the fields to be text, which is what I want.

So how do I get the little green triangles?

No idea, but I add ' to my number to force text.

Try the excel group at
http://www.microsoft.com/office/comm...s/default.mspx

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-subscribe-(E-Mail Removed)

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"TimG" <(E-Mail Removed)> wrote in message
news:77D8BEC3-DC06-454E-9664-(E-Mail Removed)...
> I use excel tables with lots of other programs. However, when I use an
> excel
> table with "text" felds which only contain numbers, these fields are
> considered numbers (not text) by these other programs.
>
> However, if the cells have little green triangles in them, these other
> programs consider the fields to be text, which is what I want.
>
> So how do I get the little green triangles?

TimG wrote:

> I use excel tables with lots of other programs. However, when I use an excel
> table with "text" felds which only contain numbers, these fields are
> considered numbers (not text) by these other programs.
>
> However, if the cells have little green triangles in them, these other
> programs consider the fields to be text, which is what I want.
>
> So how do I get the little green triangles?

And this is an Outlook issue why?