I applied a custom format to cells. The custom was adding parentheses to text. The text looked like 2010-01. After adding the custom format it looked like (2010-01). I have a worksheet with a formula that I want to read that whole cell as text, unfortunately it omits the parentheses. Only showing 2010-10. If I typed the parenthesis by hand it does not omit them.
I've tried cutting and selecting paste special to past the values so I could convert all the content of the cell to text but this has not worked.
I've tried changing the formatting to text but his removes the parentheses.