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.
Riny_van_Eekelen This does not work. It does convert the current content of the cell to text, but when I delete the text and try to enter something else, Excel interprets it as a stock symbol. In other words, it seems the cell is permanently defined as a "stock" type cell.
brianmasson Works for me. Then I don't know what's happening. Sorry!
