Need help to get single quote in every cell of Excel

[Hache hi]

I am trying to make all of the cells in a particular column (they are filled with numbers) alphanumeric and left justified by putting a single quote in front of each cell. I don't want to type the quote on each cell. How can I do this without typing in each cell.

[DanielaA]

Insert a column next to the col ; enter the below formula; copy down as required. =CHAR(39) & A1. Would be interesting to know what you are looking at. If this post helps click Yes.

[GALIENA]

Do you really need the apostrophe. There are two ways for that first select he cells and use Format > Cells > Text second you can select the cells and click the left align tool. This might do the job for you.