I have a spreadsheet that has a column of 10,000 numbers. However, they act like text. I have tried to format these by highlighting the column and trying to format the whole column. This does not work and the only way to alter these is by manually hitting the F2 key and then the Return key on each cell.
Is there a quicker way????
