How do I get the green triangles in Excel cell?

[TimG]

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?

 

[Diane Poremsky [MVP]]

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

Try the excel group at
http://www.microsoft.com/office/community/en-us/default.mspx

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[VanguardLH]

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?