"What's going on" is that Access brings a lot of overhead with it when
you cut and paste into Excel, and the overhead is causing Excel to
interpret numbers as text. In the "number" cells do you see a leading
apostrophe for each entry? If yes, do a search within this newsgroup
for workarounds.