Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transition Navigation Keys (2000)

    I keep getting apostrophes infront of all my numbers in the formula bar and when I use formulas it doesn't say they're equal but they are. It has something to do with the transition navigation keys, but when you turn it off, the apostrophes go away, but it still says they're not equal. Does anyone have any suggestions.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Transition Navigation Keys (2000)

    You'll have to be more specific or attach a sample workbook.

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Transition Navigation Keys (2000)

    When I paste in data from other files, Excel adds an apostrophe in front of the data in each cell. You cant see it on the spreadsheet, but it appears in the formula bar when the transition navigation keys are turned on. It adds an apostrophe for left justified, a carat for middle, and a quote for right. This caracter makes the cell different from other cells that it should be equal to, and when I run comparisons it say they are not equal when they really are. For instance a cell that looks blank may actually have an apostrophe in it in the formula bar and will not work with formulas. Example: (a2="","Blank","Not Blank") Even though a2 appears to have nothing in it will return Not Blank.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Transition Navigation Keys (2000)

    Are you sure that the blank looking cell is really empty apart from the apostrophe? If it contains a space, it still liiks blank, but Excel will not consider it blank, or equal to <code>""</code>.

    On my PC (Excel 2002 SP-3), a cell with only an apostrophe, carat or double quote is still considered to be equal to <code>""</code> by Excel, but a cell containing one of those plus a space isn't.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Transition Navigation Keys (2000)

    Try (example):
    <pre>=if(trim(a2)="","Blank","Not Blank")</pre>


    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •