Hi I have some downloaded data the numbers are in one column but appear on the left hand side of the cell as if it were text.
If I F2 on a cell and press enter, it turns it into a number.
How can I get them to all turn to numbers quick, without editing each cell?
Thanks
I am using Excel 2000
If I F2 on a cell and press enter, it turns it into a number.
How can I get them to all turn to numbers quick, without editing each cell?
Thanks
I am using Excel 2000