Excel - Change cell format
Posted on 2013-11-22
I have a column which includes a list of telephone numbers.
All values are marked as numbers and data appears like " 3.0212212+11"
What I want to do it to make number appear as "302101234567"
So, I change the format of all cells to text.
Although all the cell change their format to text, I have to enter each cell to update the value: this means that I have to click each cell, press F2, and move on to next cell.
Is there a way to update all cells automatically?
ctrl+shit+alt+f9 is not working!