Forum Discussion
Removing data type from cell
I applied the "stocks" data type to a cell. How do I remove the data type from the cell so that I can use the cell for plain text without Excel interpreting my entry as a ticker symbol?
brianmasson Select the cells, right-click and then Data Type, Convert to Text.
It doesn't work in 365. Nothing gets rid of the datatype. I'm having the same problem with Geography. I don't get the "datatype" in the dropdown. I went in and changed datatype in the menu to text -- didn't fix it. I tried copying to a different row and pasting as 123 text, didn't work. I tried using a formula to copy from that cell, didn't work.