How do I get the green triangles in Excel cell?

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Unread messages not appearing in inbox I have emails in the unread email folder that do not appear in my inbox. How do I fix this and can I get rid of the unread email folder? Tag: How do I get the green triangles in Excel cell? Tag: 598205
  - 2
    - Outlook deletes self-addresses emails Somewhere along the line I added myself to the junk mail filter (at least that's where I am assuming I did this horrible deed) and even after deleting my address from the junk mail filter, turning off the junk mail filter, reinstalling Office 2003 (couldn't repair, had to go the whole Windows Install Cleanup route), it is still happening. This is a work machine on an Exchange server. The mail is reported as being delivered in the Message Tracking Center, and in fact I can watch it show up in my inbox then immediately disappear. It does NOT end up in the trash...it is permanently deleted. Then 15 seconds later the New Mail Desktop Alert on the taskbar reports that the message has been received and when I select that popup I get the message "The Operation Failed". I'm lost. Any help? Thanks in advance, Steve Tag: How do I get the green triangles in Excel cell? Tag: 598204
  - 3
    - Unread mail Messages are going into my unread mail folder but not into my inbox. What is this and how can I fix this or eliminate my unread mail folder? Tag: How do I get the green triangles in Excel cell? Tag: 598202
  - 4
    - Blackberry causes my outlook to consider messages as read(unbold) Ever since I set up my blackberry to receive my e-mail, the messages in my outlook appear as read. How can i stop this so that I make sure to read all my messages at work and not miss any. Tag: How do I get the green triangles in Excel cell? Tag: 598199
  - 5
    - HTML Email Link Unclickable (Is it too long?!?) Outlook 2007 I have an HTML email that has a long URL in it (maybe 1000 characters in length). In Outlook 2007, the link is shown with the full URL; however, when I try to click in it it doesn't work. I then booted the email up in Outlook 2003 and it works. Is there a max size for a URL in Outlook 2007 that is different than Internet Explorer and Outlook 2003? The email address of the sender is on my white list. If I click to Edit the message and then Edit the hyperlink the text and the URL is not displayed. This seems like a bug in Outlook 2007? Any ideas on how to get around this? I get a few of these a day and it's annoying to have to go into Outlook 2003 and see them. Tag: How do I get the green triangles in Excel cell? Tag: 598198
  - 6
    - OWA Does anyone know what the link is for the Outlook Web Access newsgroup? Thanks! Tag: How do I get the green triangles in Excel cell? Tag: 598191
  - 7
    - Junk E-mail Protection in Outlook 2007 I am running Outlook 2007 under Vista Home Premium. I have my Junk e-mail Option set to allow only mail from people or domains on my Safe Senders List or Safe Recipients List to be delivered to my inbox. Safe Senders includes e-mail from my contacts. Yet, I am getting tons of spam from senders that are not on my Safe Senders List and not on my Safe Recipients List and not on my Contacts list. What am I missing? I am a new user of Outlook, so I'm not very familiar with it. My e-mail account is type HTTP. I have read your references to slipstick, but could not find an answer. Tag: How do I get the green triangles in Excel cell? Tag: 598186
  - 8
    - Company Merger - Moving Existing Appointments to Another Server We have aquired a new clinic and they use Outlook. We also use Outlook. So we are trying to figure out if there is a way to migrate their appointments into our environment without losing or having to recreate their appointments. Does this make sense? We use XP and I am not sure about them at this point. Thank you, Lisa Tag: How do I get the green triangles in Excel cell? Tag: 598184
  - 9
    - Locking the TO or CC or BCC fields I am needing to know if there's a way to "lock" or "gray out" the TO and/or CC and/or BCC fields on an e-mail template. Once I save an outlook template, is there a way to lock the intended recipients so that no matter who sends the form, there is not a way to have it get changed from where it needs to be sent? Tag: How do I get the green triangles in Excel cell? Tag: 598181
  - 10
    - Send Request and not delete Hello, Is there a way to send a re-occuring meeting request or appointment so the person you are sending it to is unable to delete it? So the only way it can be deleted is by the person who sent it. Thanks!! Tag: How do I get the green triangles in Excel cell? Tag: 598180
  - 11
    - outlook 2007 won't close properly When I start my PC, outlook opens fine. When I close it and try to reopen, it doesn't. Outlook.exe shows up in task manager twice and if I force it to close, it will reopen. Sometimes it asks if I want to open in safe mode.What's wrong?? Tag: How do I get the green triangles in Excel cell? Tag: 598178
  - 12
    - reinstalling outlook for the past 2 days all emails were going into junk folder our it guy told me to reinstall outlook which i did now i have nothing. when i open outlook i get the mail set up box with email set up, data files and show profiles and am only able to access show profiles. Can anyone walk me thru getting this set up as my job depends on emails and at this point i can't send or receive. Thanks Tag: How do I get the green triangles in Excel cell? Tag: 598174
  - 13
    - How to send email as another user I need to send email AS another user (Send As not send on behal-of). Does anyone know how to do this in Outlook 2007. Thanks. Tag: How do I get the green triangles in Excel cell? Tag: 598171
  - 14
    - How to Outlook send a E-mail When I send a email to anyone@domain.com how to Outllok check or validated this email address. Look for a cache file (.nk2) and validated? I need know how to works outlook before send to a smtop server. Could you help me? I appreciate JGG Tag: How do I get the green triangles in Excel cell? Tag: 598159
  - 15
    - Problem with Distribution list I use Outlook for my email program. I use several distribution list so have a working knowledge of how the idea works. I am experiencing difficulty however. In one of my lists, I get almost immediate replies from the system listing several addresses that were not delivered. The email addresses are listed in the message. I have then highlighted te link in the message failure notice and created a new single address email to that "failed address" and without fail, they are delivered. I have checked for errors in typing and all the obvious pitfalls. but still experience problems. If anyone has a suggestion, I would appreciate you help and interest. Some of the delivery failures are part of another distribution list that has no problems. Thanks in advance for any help or suggestions. Tag: How do I get the green triangles in Excel cell? Tag: 598152
  - 16
    - Emails going to Contacts instead of Inbox I have a user who tried to save a lsit of email addresses from an email by dragging it to her Contacts area from the Inbox. Now all of her emails are going there. Can you help me fix this? I have tried highlighting emails and dragging them back to her Inbox through the mail, but it just moved those and does not send new emails into the Inbox. The two of us in our IT department and our executive director have not seen this before and neither has our email host provider. -- Terry Tag: How do I get the green triangles in Excel cell? Tag: 598135
  - 17
    - New Contact Storage Location When I create a new contact it saves it to an alternate contact location versus my main contact location. And, it does not give me the option to choose from the main or alternate list. 1) How do I set the default location for new contacts to be saved to? 2) How can I change the location/list that the contact was saved to? Tag: How do I get the green triangles in Excel cell? Tag: 598128
  - 18
    - Global Address List not diplaying all users We are using Outlook 2003 with Exchange v6.5.7638.1. When I create a new user in active directory, they will not appear to some end users in the company Global Address List when looking for their address to email to. We can find the users in "All Address Lists" - "All Users", but most users do not know to look there. I was wondering if this is a common issue and if there is a fix for this. Any help or advice would be greatly appreciated. -- Thank you, Brian Tag: How do I get the green triangles in Excel cell? Tag: 598121
  - 19
    - Messages not going to correct sent item folder Hello, In my outlook I am responsible for 2 email accounts. 1 is my general mail box and the other is our info@xxxxxx.com mail box. I monitor and reply to customers that email us for additional information. Each mail box has a sent items folder, however when I send and email from the "info" mailbox, the sent items are being stored in my general box. Is there any way to set a rule or something to keep these differnet email types separated? Tag: How do I get the green triangles in Excel cell? Tag: 598108
  - 20
    - Show From button Is there any way to turn off the "Show From" button in Outlook 2007? when you click on New for a new email and then go to options there is a Show From button. We do not want people to be able to use that. How Do I turn that off? Thanks Tag: How do I get the green triangles in Excel cell? Tag: 598106
  - 21
    - Outlook 2003 Crashes, and crashes, and crashes... I'm running Outlook 2003 in XP. All latest updates have been installed. Issue began on August 8, two weeks ago. I was trying to install a Samsung SW tool to synch a new phone, which I was never able to make work, so I uninstalled it. I have run a system restore, scanpst, detect and repair, updates on virus/firewall SW (Norton), created a new profile, and done a repair/reinstall on Outlook. My HP Officejet 6110 connected via USB also sometimes seems to "disappear" and the system re-installs it. I've re-installed it and checked SW versions and I am current. Here's the info from event manager from the last crash: Event Type: Error Event Source: Microsoft Office 11 Event Category: None Event ID: 1000 Date: 8/21/2008 Time: 9:10:13 AM User: N/A Computer: RANDYVAIO Description: Faulting application outlook.exe, version 11.0.8217.0, stamp 480f95d9, faulting module ntdll.dll, version 5.1.2600.2180, stamp 411096b4, debug? 0, fault address 0x000118d2. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 41 00 70 00 70 00 6c 00 A.p.p.l. 0008: 69 00 63 00 61 00 74 00 i.c.a.t. 0010: 69 00 6f 00 6e 00 20 00 i.o.n. . 0018: 46 00 61 00 69 00 6c 00 F.a.i.l. 0020: 75 00 72 00 65 00 20 00 u.r.e. . 0028: 20 00 6f 00 75 00 74 00 .o.u.t. 0030: 6c 00 6f 00 6f 00 6b 00 l.o.o.k. 0038: 2e 00 65 00 78 00 65 00 ..e.x.e. 0040: 20 00 31 00 31 00 2e 00 .1.1... 0048: 30 00 2e 00 38 00 32 00 0...8.2. 0050: 31 00 37 00 2e 00 30 00 1.7...0. 0058: 20 00 34 00 38 00 30 00 .4.8.0. 0060: 66 00 39 00 35 00 64 00 f.9.5.d. 0068: 39 00 20 00 69 00 6e 00 9. .i.n. 0070: 20 00 6e 00 74 00 64 00 .n.t.d. 0078: 6c 00 6c 00 2e 00 64 00 l.l...d. 0080: 6c 00 6c 00 20 00 35 00 l.l. .5. 0088: 2e 00 31 00 2e 00 32 00 ..1...2. 0090: 36 00 30 00 30 00 2e 00 6.0.0... 0098: 32 00 31 00 38 00 30 00 2.1.8.0. 00a0: 20 00 34 00 31 00 31 00 .4.1.1. 00a8: 30 00 39 00 36 00 62 00 0.9.6.b. 00b0: 34 00 20 00 66 00 44 00 4. .f.D. 00b8: 65 00 62 00 75 00 67 00 e.b.u.g. 00c0: 20 00 30 00 20 00 61 00 .0. .a. 00c8: 74 00 20 00 6f 00 66 00 t. .o.f. 00d0: 66 00 73 00 65 00 74 00 f.s.e.t. 00d8: 20 00 30 00 30 00 30 00 .0.0.0. 00e0: 31 00 31 00 38 00 64 00 1.1.8.d. 00e8: 32 00 0d 00 0a 00 2..... I have searched the forums and tried everything I have found, but I'm stumped, and the issue sometimes occurs every few minutes. Does it even while in the background. Tag: How do I get the green triangles in Excel cell? Tag: 598104
  - 22
    - Script error I normally use Office Outlook 2003 for email and have recently encountered problems when trying to use search engines (Metacrawler and Ask.com) to surf the internet. I am using Windows XP Home v5.1 Build 2600 sp3 and Internet Explorer 7 v7.0.5730.11. When performing internet searches using a search engine, I consistently encounter an "IE Script Error, error has occurred in the script, line xx, char yy, Error: could not complete the operation due to error zzz04005". The xx,yy, and zzz values vary depending on the search but the 04005 is consistent. This has occurred ever since I installed sp3 for Windows XP and occurs when I access the internet while I have Outlook active. However, if I access the internet without going through Outlook, the very same search and search engine works fine. So, I am assuming the problem is caused by Outlook. Any ideas on how to fix the problem? Thanks Tag: How do I get the green triangles in Excel cell? Tag: 598103
  - 23
    - How do I read a message in Content-Transfer-Encoding: base64 Sometimes server performance reports arrive with Content-Transfer-Encoding: base64 and it's not readable. I understand that exchange will do that when content has some number of 8 bit characters. Is there a way to get outlook to read these reports or is there some way to get exchange to turn off the 64bit encoding? I am using Office 2007. -- SteveH Tag: How do I get the green triangles in Excel cell? Tag: 598101
  - 24
    - E-mail folder vanishes when doing a drag/drop to a Personal Folder I have a user who created a new Personal Folder in her Outlook and then proceeded to drag another folder from her regular Inbox to the new folder but when she dropped it there the only thing that happened is that the Folder is gone from her Inbox and does nto show up in the new personal folder. Tried doing searches and have expanded ALL of her trees but we cannot find that folder any where. Any ideas on what may have happened? User is using Outlook 2003 with the Use Cached Exchange Mode option turned on. Tag: How do I get the green triangles in Excel cell? Tag: 598099
  - 25
    - Not receiving emails with attachments I am not receiving about 50% of my emails with attachments into Outlook - xp office version. They will come to the web-based yahoo server, but never end up in the Outlook inbox or any other file. Any ideas? Tag: How do I get the green triangles in Excel cell? Tag: 598098
- Next
  - 1
    - Exporting Tasks from Outlook to Excel - Notes truncated I'm using Office 2003 Pro and tracking Tasks in Outlook. When I export them to an Excel file, the notes field gets truncated at 255 characters. Is there a way around this without a 3rd party application or copy and paste? Tag: How do I get the green triangles in Excel cell? Tag: 598097
  - 2
    - Office Button does nothing when clicked I have a user that will be composing a new email, creating a new appointment, etc and when he clicks the Office Button nothing appears. Has anyone ever seen this? Thanks is advance for any suggestions! -- Chris R. Rufkahr Senior Wine Consultant, The Traveling Vineyard GET PAID TO TASTE WINE!!! Find out how at: http://www.myttv.com/chris12274 Tag: How do I get the green triangles in Excel cell? Tag: 598096
  - 3
    - Problem color-coding messages by sender Hi, I have successfully color-coded messages from my boss, "Joe Blow", to red in my Outlook 2003 in-box. I have also color-coded messages from a director, "Anna Smith", in green. I followed the steps of highlighting a message from that sender and going through the Tools option, etc. on the menu bar. My problem is that *any* messages coming from a user with the first name "Joe" are color-coded in red. Also, *any* messages coming from a user with the last name "Smith" are color-coded in green. I don't know what will happen if I get a message from someone named "Joe Smith"! Has anyone encountered / fixed this problem before? Thanks for your help! Tag: How do I get the green triangles in Excel cell? Tag: 598095
  - 4
    - Outlook 2007 asks for profile everytime. Want it to stop. Everytime user opens Outlook 2007 (Exchange) it asks which profile they would like to use. There is only 1 profile on the system and user doesnt want this to pop up each time. Is there a way to change outlook so it wont ask this user anymore? I verified there is only 1 profile in his Outlook and it is set as default and always use. Tag: How do I get the green triangles in Excel cell? Tag: 598093
  - 5
    - How do I cancel the User Account Control appearing on Outlook 2007 Having problem with the program needing permission window appearing before Outlook will open. Any ideas how I can stop this happening please. Also, When Outlook does open, I get the following Error 623 - could not find phonebook entry for this address All help welcome - thanks Tag: How do I get the green triangles in Excel cell? Tag: 598091
  - 6
    - Attachments arriving as ATT000XX.dat in O2003SP3 -but not in SP2 When Outlook 2003 doesnt like the attachment filename its sometimes converts it into ATT000XX.suffix. On our Outlook 2003 SP2 receiving clients the suffix still is intact and hence its no problem for user to open it (e.g ATT00054.pdf). Our frustrated secretary has Outlook 2003 SP3 (also std with same lang), and receives the mailcopy attachment as ATT000XX.dat, and hence dont know what program to use for opening it (because of the suffix now being "dat"). Exchange is not involved, sofar no other client differences then SP2/3 has been found. The phenomena typically appears when sender is non Windows user. (I think it might be related to whether RFC standard 2232 or 2017 is used) Is it possible to uninstall SP3 ? Would Office 2007 preseve the suffix ? Grateful for any solutions Tag: How do I get the green triangles in Excel cell? Tag: 598088
  - 7
    - Rules set date to "None" I have rules set up to move emails to different folders when they arrive. When the rule moves the email and I look at the email in the folder it was moved to, the date says "None". They are all below the dated ones. If I click on the email, it gives it a date and sorts it to the correct area with in the date field. This also happens if I manually drag the emails to any folder. Please tell me there is a fix for this. I get hundreds of emails a day and having to select each one so that it can be correctly sorted is driving me crazy. Tag: How do I get the green triangles in Excel cell? Tag: 598087
  - 8
    - Sent Email is automatically deleting My sent email is auto deleting every day. I have right clicked the folder and changed settings in auto archive to: don't archive. Still no changes?? Tag: How do I get the green triangles in Excel cell? Tag: 598082
  - 9
    - Tasks/Appointments Hello, I was wondering if it was possible to send someone a reoccurring task or Appoinment request and make it where they cannot not delete it or removed it; Only the person who sent it can delete it by sending a delete task or something. Similar to when you create a meeting and a person accepts and the person who created it can delete from everyone's calendar except in this case, the person who it is sent to cannot remove it like it's a read only. Thanks!! Tag: How do I get the green triangles in Excel cell? Tag: 598078
  - 10
    - Deleting addresses from an expanded Distribution List I have created a Universal Distribution Group in Active Directory for my IT department; the one problem we're having is when someone expands the list in Outlook to delete addresses from it. When that happens, the sender gets NDR's for several recipients, but if we send a message to the entire group and expand the list, it works fine; it only seems to be a problem if someone removes an address form the list. Can anyone point me in the right direction, please? Thanks! Tag: How do I get the green triangles in Excel cell? Tag: 598076
  - 11
    - Outlook doesnt synchronize my hotmail e-mails anymore Please can you help?! I have Outlook 2007 and through Outlook Connector I use my hotmail account there. I just came from 7 weeks holiday, turned on my Outlook and was shocked to see no new messages in my inbox since the last time I used it 7 weeks ago. Outlook wouldn't synchronize my webmail. When I push Send/Receive button it says its completed with no errors, but the messages are not coming through. When I go to my hotmail account through a browser, hotmail account functions properly and I have plenty new messages, so the problem must be in Outlook. I don't know if that matters, I use Vista. Please can anyone tell me what happened and how can I fix it! Thank you!!! Natalija Tag: How do I get the green triangles in Excel cell? Tag: 598075
  - 12
    - Outlook 2007/2003 market share I would like to know how the installed base of Outlook 2007 compares to Outlook 2003. Any idea on where I can find this information? I am wondering about adding a program feature that would only be available to Outlook 2007 (and later Outlook versions) users. -- Frank Tag: How do I get the green triangles in Excel cell? Tag: 598074
  - 13
    - Calendar Printing We just installed Office 2007 to replace 2003. Appointments on my calendar are color-coded. When I print a calendar on our Dell color laser printer, the colors are very faded or dim. When I previously printed the same calendar in 2003, the colors were more intense. How can I correct this problem in Outlook 2007? Tag: How do I get the green triangles in Excel cell? Tag: 598073
  - 14
    - Outlook will not open Outlook has stopped opening Tag: How do I get the green triangles in Excel cell? Tag: 598070
  - 15
    - Scanpst Aborts without making changes - HELP I have posted this on another forum and have not had any luck in a response. Hope you all can help. I receive an error when I load Outlook 2007. My pst file cannot be opened and I should run the Inbox Repair Tool (scanpst) to fix. When I do that, scanpst gets to a point where it aborts and no changes were made to the file. I have run scanpst 5 or 6 times and each time I get the same error. Outlook cannot open the file in normal OR safe mode. I have also run the disk error checking program and defragged the drive. Still no luck ... I am running Windows Vista Ultimate, 32 bit. I have booted in safe mode and stopped everything I could prior to running scanpst. I have also executed the program as administrator. In all cases, I received the same error message. I have also scoured the Microsoft communitities and KB for help and have found nothing about this problem. The error I am receiving is a scanpst error so either I have a unique problem or Outlook has some kind of a bug. The file is large ... ~6GB. Are there any software repair utilities that are reasonably priced? Any other technical advice you can provide would be greatly appreciated. Thanks in advance for any help ... Tag: How do I get the green triangles in Excel cell? Tag: 598068
  - 16
    - Outlook 2007 not showing "new messages" in inbox... My inbox folder on the left will indicate new messages, yet there is nothing new in my inbox. I have to click another folder, then click the inbox folder again for my new messages to show up in the actual inbox... Anyone else have this problem? Thanks - Marc Tag: How do I get the green triangles in Excel cell? Tag: 598067
  - 17
    - Opening, deleting, accepting, declining tasks I am using Outlook XP and cannot open, accept, decline or delete tasks. Does anyone know why? I have tried "repairing" outlook with the set up disk, but that didn't work. When I try to do any of the above things with tasks a message pops up that says "cannot do this type of action on this type of attachment". Tag: How do I get the green triangles in Excel cell? Tag: 598065
  - 18
    - Outlook 2003 Error I get this error in Outlook 2003: Error Signature szAppName:OUTLOOK>EXEszAppVer:11.0.5510.0 sz MODNAME:hungapp szModVer:0.0.0.o offset:00000000 Technical Information c:\DOCUME~1\BARBAR~1LOCALS~1\TEMP\WER7da4.diroo\OUTLOOK.EXE.mdmp c:\DOCUME~1\BARBAR~1LOCALS~1\TEMP\WER7da4.diroo\appcompat.txt What is it and how do I resolve the issue? Tag: How do I get the green triangles in Excel cell? Tag: 598063
  - 19
    - I need help!! with OUTLOOK!! I am trying to force the reply to all Outlook messages in HTML. The only software that does this, that I have found, is Bells and Whistles. Bells and Whistles has problems and stopped working after a year. There must be another similar app out there. Anyone know of one? Tag: How do I get the green triangles in Excel cell? Tag: 598061
  - 20
    - Postmarking I am a longtime user of Outlook and now have 2007 with Vista. When I send a single message the status bar says "Sending Message 2 of 2" or words to that effect. Is that because I have postmarking turned on? If not, how do I get it to show the correct number? Tag: How do I get the green triangles in Excel cell? Tag: 598054
  - 21
    - Printing an email Hello can somebody help me please? I am having a problem with printing an email. When you click on the print icon it comes up with a message saying "Could not open the item, try again" despite the email being open. Any ideas please? Thanks. Tag: How do I get the green triangles in Excel cell? Tag: 598053
  - 22
    - don't want other peoples e mail addresses to show; only names I don't want other people's e mail addresses to show; only their names when I send e mail Tag: How do I get the green triangles in Excel cell? Tag: 598052
  - 23
    - Not receiveing Outlook Appointment Meeting Email My manager has been sending me an Invite for a scheduled meeting, However, I never receive the email. But I get all other emails. what do I need to look at that would cause just this particular email not to showup in my inbox? Tag: How do I get the green triangles in Excel cell? Tag: 598049
  - 24
    - Outlook 2003 replying automatically to deleted or moved messages I just recently started having this problem. If I move a message I want to keep from my inbox to another folder, or if I delete a message, Outlook, without notifying me, automatically sends a reply to the sender, but only the sender. No text in the message area, just blank. What could be causing this and how do I fix it? Any help appreciated. Tag: How do I get the green triangles in Excel cell? Tag: 598046
  - 25
    - Printing saved outlook e-mails As references I need to save previously sent emails. However, a majority of these e-mails I originally create in Excel and copy/paste special into outlook. I have tried every paste special option but when I print, it only prints the first page of information. It will print my signature on the second page but if the copy and pasted "image" or "excel worksheet" length runs into two pages, it will simply cut it off. Does anyone have any suggestions? Tag: How do I get the green triangles in Excel cell? Tag: 598045

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?

Re: How do I get the green triangles in Excel cell? by Diane

Diane
Thu Aug 21 15:46:41 PDT 2008

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: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

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.

"TimG" <TimG@discussions.microsoft.com> wrote in message
news:77D8BEC3-DC06-454E-9664-3A680A16F2A6@microsoft.com...
> 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?

Re: How do I get the green triangles in Excel cell? by VanguardLH

VanguardLH
Sat Aug 23 16:24:07 PDT 2008

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?