To convert "Text Numbers" to numbers is easier than that.

Type a number one in a spare blank cell and then copy the cell.

Highlight the text numbers that need to be converted, right click, paste
special, select multiply in the Operation area.

Click ok out of it. The text numbers are now numerical numbers.

Enjoy

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------
"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?