Removing data type from cell

brianmasson 

I had the same issue with converting to text not working as soon as I tried to change what was in the cell. This work-around worked for me.

1.) Go ahead and do that first step already mentioned: Select the cell, right-click and choose Data Type=>Convert to Text.

2.) Go to an unused cell in the spreadsheet, select it, right-click and choose Format Cells. Then, on the Number tab, choose Text.

3.) In that cell, type the text you wanted in the original cell, then cut and paste it into the original cell. For me, that finally worked. Excel doesn't force it back to the Stocks data type. Hope this helps.