Results 1 to 4 of 4

Thread: Putting The Green Triangle Back In An Excel Cell

  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Putting The Green Triangle Back In An Excel Cell

    I have got a spreadsheet that needs to have the green triangles shown so that when the sheet is transferred to a different program, the program software can read what is in each cell. Thing is, that when you alter a cell, the green triangle disappears. When I've checked the cell format, ones with green triangles and ones without, are all formatted the same - as text. What we enter is thing slike this 60,61,110 - IE a group of numbers with apostrophies. Any idea how to keep the damn triangle?

  2. #2
    Join Date
    Jan 2006
    Posts
    605

    Re: Putting The Green Triangle Back In An Excel Cell

    If any of the data is used mathematically and has the green triangles, I would recommend correcting them. To correct this, I'll sometimes copy the entire range to Notepad, select it from there and copy it back into the original spreadsheet to remove these. If you have just a few, you can hover over the cell and click on the dialogue box to correct them that way as well.

  3. #3
    Join Date
    Feb 2012
    Posts
    2

    Re: Putting The Green Triangle Back In An Excel Cell

    Aparently my customer needs the green triangle there for his software to read the spreadsheet. So I need them there all the time but its when I change an existing cell, the triangle disappears and if this is put through the spftware, the device can't read the cells without the green triangle.

  4. #4
    Join Date
    Dec 2007
    Posts
    2,291

    Re: Putting The Green Triangle Back In An Excel Cell

    Can you just go to Tools and then Options and select the smart tag option. Then those triangles should appear all the time that you want. If you click the cell, a different icon appears with a drop down arrow you can click for options. I don't know if this is what you wanted to hear, but its the best I've got.

Similar Threads

  1. Replies: 2
    Last Post: 04-01-2012, 06:54 PM
  2. Replies: 5
    Last Post: 27-05-2011, 10:43 AM
  3. Putting Nokia N73 back to factory settings.
    By AnaMika in forum Portable Devices
    Replies: 6
    Last Post: 08-06-2010, 11:31 PM
  4. What is the red square, green circle, blue triangle in the box
    By Dharmavira in forum Operating Systems
    Replies: 3
    Last Post: 24-07-2009, 01:45 PM
  5. A white box contains Red square, Green circle and Blue triangle
    By robin45 in forum Technology & Internet
    Replies: 3
    Last Post: 22-07-2009, 11:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,727,311.03949 seconds with 18 queries