If you trade Missingno to Gold, Silver, or Crystal (the new games that you can even trade from Red/Blue/Yellow with Missingno) it will usually become one of the new species (although with Missingno attacks), but there still is a chance it could remain just plain wack.
And if you trade Missingno to Ruby or Sapphire, it proceeds to rape May, apparently.