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.

  • 1
    show us the sutom format you used – PeterH Jun 18 '18 at 7:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.