Thanks LNBruno!
It's very strange, when I do "paste special", the default is "Microsoft Excel 8.0 format". This format pastes the values as text. If I try ANY of the other special formats (Biff5, HTML, Unicode Text, Text, or CSV), it pastes the values correctly.
Has anyone...