Occasionally when I export data from some other applications to excel, they will not be recognised as, say, numbers unless I activate each cell. If I try Format/Cells and select Number, this will have no effect - it is almost as if excel does not realise there is anything in the cell.
As a result, I end up having to highlight all the data then press F2,Enter,F2,Enter,F2,Enter,F2,Enter... etc. which can obviously take a very long time!
Has anyone else had this problem and found a way around it?
Any tips would make my tired fingers very happy!
As a result, I end up having to highlight all the data then press F2,Enter,F2,Enter,F2,Enter,F2,Enter... etc. which can obviously take a very long time!
Has anyone else had this problem and found a way around it?
Any tips would make my tired fingers very happy!