I cannot paste values as numbers

  • Thread starter Thread starter msnyc07
  • Start date Start date
M

msnyc07

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.
 
create a new column. Multiply the value in your existing column by 1, thus
forcing the numeric format.
 
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
 
Back
Top