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:
[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
[email protected]

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?