I have a spreadsheet with a column that has been formatted as text.
The column contains all numbers. I wish to copy this column into
another sheet that has the column formatted as numbers. When I do so,
it does not treat the entries as numbers, even when I paste only the
values. Any thoughts?