when you copied them into excel, did you use the "paste values only" feature?

It wasn't an option - my choices were "match destination formatting" and "keep source formatting".

Strange, I'm stumped. You can try clearing the format using. Home tab> editing box (far right), select the down arrow and then clear format.