none
Number in this cell is formatted as text or preceded by apostrophe RRS feed

  • Question

  • Hey

    I am working with excel sheet using openxml in c#. I have inserted numbers(converted to string)  in excel sheet. But In excel sheet I am getting the error "Number in this cell is formatted as text or preceded by apostrophe".  I want to insert numbers in form of text. How can i ignore this error programmatically so that it doesn't show any error.

    I have studied about numberformats to remove this error. But I don't know how to use it. Please help.

    Thanks


    • Edited by AmanVerma Sunday, June 30, 2013 6:01 AM
    Saturday, June 29, 2013 6:48 AM

Answers