"Cheri" wrote in message
...
Here's what I have: Spreadsheet with column of currency that was
formatted
as "text". I inserted a column to the right - put in formula =" "&A1 and
the
numbers then appears as numbers (without the little green tab in the
corner).
Then I wanted to delete the first column but can't because formula refers
to
it. I inserted a third column, copied 2nd column and paste special
(values)
but the text tab reappears. Is there some way to eliminate the original
text
column or copy the second column and keep it formatted as just number or
currency?

I don't think the little green tabs have anything to do with it being text
or not.
The formula =" "&A1 will not convert text to a number. Its result is
definitely text.
To convert text to a number use =VALUE(A1).
Copy and paste special (values) on the results of this and you should
achieve what you want.