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?
This works, but not a great fix for 100s of 1,000s of rows. 😕 MS needs to fix this.
Completely agree. It's a kludgey, clunky band-aid, but I just thought I'd share for the users who might find it useful until 2047 when MS gets around to fixing it.