In excel I have many cells of number in a column formatted as text. I want to convert them into a formatting "number stored as text". I can do it for a single cell at a time by putting an apostrophe (') before the number and pressing enter. My problem is how to achieve this type of formatting for rest of the cell quickly. I have tried to create a new column as ="'"&A2 and copy, but it does not work.
In the attached figure I have converted cell A2 as number formatted as text by putting an ' before it and want to do the same for rest of the cell quickly.