Depending on the version of Excel, you should get a
caution sign next to the cell when you highlight a number
stored as text.
When you put your cursor over the caution sign, it gives
you the option to convert the number stored as text to a
number.

If highlight a range that has a number stored as text at
the upper left, the convert will work for the whole range,
but you might have to scroll back to the upper left of the
range to see the caution sign

-----Original Message-----
We have a software package from which we can export data
to MS Excel.
However, when exported it arrives in Excel as text. Even
though they are
numbers, they act like text. The only way to convert
them text to numbers is
to edit the cell (press F2) and hit enter. I've tried
every other method of
copying and pasting (even pasting special), but nothing
seems to work. Any
ideas?
.