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.