Removing data type from cell

New Contributor

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?

3 Replies

@brianmasson Select the cells, right-click and then Data Type, Convert to Text.

@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!