Results 1 to 4 of 4

Disappearing numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Disappearing numbers

    Could anyone tell why and how I can change my cells show I can have my numbers appear.

    I have a 45 number column (K) setup with the following formula:

    =IF(OR(ISNUMBER(FIND($B$7,H9,1)),ISNUMBER(FIND($N$7,H9,1))),"",H9)

    This gives the standard "0" until numbers are pasted in column H.

    I pasted 30 numbers and BLAM! the "0" disappears no sorted numbers appear.

    This just started today. I have two other areas I use this formula and everything works just fine.

    Does anyone have clue why this is happening just in the column. I've checked whether the column cells were text or numbers and it was numbers on both incoming group and column H.
    Last edited by khank; 01-02-2011 at 12:47 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1