Thank you for contacting us.
A cell will display its literal content if its format is set to Text. The following snippet assigns the cell A1 in the active worksheet a formula value and sets its format to Text. As a result, A1 will display =SUM(1, 2, 3)
instead of 6
If you would like to apply the Text format to all entered values in a worksheet, feel free to use the following sample code:
CellSelection cellA1 =
"=SUM(1, 2, 3)"
Worksheet activeWorksheet =
I hope you will find my answer helpful. Let me know if you have further questions.
the Telerik team