software

I have a file I exported from another program so that I can work with it and
the numbers export as text. I need to convert the text to numbers so that I
can count, sum, average, etc. I tried selecting and formatting to a variety
of different number formats and even copying and paste special as value and
number formats. Can anyone suggest a solution?

You could use a helper column and enter the formula:

=VALUE(A1)

and copy this down. You could fix the values using lt;copygt;, Edit | Paste
Special | Values | OK, and then paste the values to overwrite the
originals.

Another way is to enter a 0 into a blank cell, then lt;copygt; that cell,
then highlight all the cells that you want to convert and Edit | Paste
Special | Add | OK then lt;Escgt;.

Yet another way is to highlight the column(s) with numbers in, then
Data | Text-To-Columns and on the first panel click lt;Finishgt;

Hope this helps.

PetePaste special doesn't work for some reason as it was one of the first things
I tried, but I got there with Text to columns. Thanks.

quot;Pete_UKquot; wrote:

gt; You could use a helper column and enter the formula:
gt;
gt; =VALUE(A1)
gt;
gt; and copy this down. You could fix the values using lt;copygt;, Edit | Paste
gt; Special | Values | OK, and then paste the values to overwrite the
gt; originals.
gt;
gt; Another way is to enter a 0 into a blank cell, then lt;copygt; that cell,
gt; then highlight all the cells that you want to convert and Edit | Paste
gt; Special | Add | OK then lt;Escgt;.
gt;
gt; Yet another way is to highlight the column(s) with numbers in, then
gt; Data | Text-To-Columns and on the first panel click lt;Finishgt;
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

You're welcome - thanks for feeding back.

Pete