After wreaking havoc in Florida, Nicole weakened into a post-tropical cyclone, bringing severe thunderstorms to the Carolinas and Virginia Friday before striking the Northeast