Copying values

[gscarter]

can you do just change formatcells for all cells to text?

I've tried this, when i select general it leaves it in the second format, when i select number it turns it into a huge number because it is picking up the E as exponential.