Okay, so here is my dilema.

In a column, I have numbers like 123456789 and 234567890 (all are 9 digits long). However, when you select the cell, you can see that each of them is preceeded by a " ' " character that apparently is hidden from view. For example '123456789 and '234567890.

I need to format these cells, but in order to do so, I need to get rid of the " ' " character preceeding each of the numbers in my column. Is there a way to concatenate or convert each of the numbers such that they no longer have the " ' " preceeding them?

Thanks in advance!