I found the problem. The entries all had a trailing space so were being
treated as text regardless. So I did

=(LEFT(F26058,9))*1

and it worked out.

Thanks

"msnyc07" wrote:

If you mean as in =C1*1 I did that and get #Value!

"TC" wrote:

create a new column. Multiply the value in your existing column by 1, thus
forcing the numeric format.

"msnyc07" wrote:

I copied a column of data off the internet, tried pasting both as Special
(Values) and normal.

In both cases the column with #s does not 'take'.

Even though I set the formatting as Number/2 Decimal Places it will not add
the decimal places nor will it sort.

I copied and tried to repaste as Special/Values an no matter what I do it
won't recognize as #s.

Any thoughts appreciated.