I got what I wanted. Cell.Value2 = "'" + CellValue2.
But what I was trying to achieve still failed. I wanted the little green arrow to go away and in other sheets I have it was accomplished by referencing the cell that has the '5. The original cell is flagged but any referencing cells are not.
Basically, you can ignore this post.
RARajesh A Syncfusion Team July 19, 2013 06:17 AM UTC
Thank you for using
the Syncfusion products.
We have analyzed your code snippet
and we could suspect it’s a usage issue. We have updated the possible code
snippets for “converting the Number to as text”and also we have attached the sample for your reference.
Please make use of this and let us know if this helps you.