I have a list of karaoke CDs in excel that was input by somene else.
When inputting entires such as 09-09 the cell defaulted to date format so she input it as 09=09. I set the format for that column to text and did a search and replace but it still defaulted to date.
I tried pasting into word doing search and replace and then pasting back into Excel with the same result.
If I paste just one cell it's ok but not when I paste the whole column.
Grateful for any help on this.