Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Avoid Formatting Cells as Text

Best Practice

When using the Jet Excel add-in, setting the format of a cell to Text can cause problems.

When you format a cell as Text , the formula itself becomes the value of the cell and Excel does not evaluate it.

textformat.png

Since the Jet Excel add-in assumes that Excel will evaluate any formula entered into a cell, this can be a problem. It is best not to set the format of a cell as Text.

Published:

Avoid Formatting Cells as Text

Best Practice

When using the Jet Excel add-in, setting the format of a cell to Text can cause problems.

When you format a cell as Text , the formula itself becomes the value of the cell and Excel does not evaluate it.

textformat.png

Since the Jet Excel add-in assumes that Excel will evaluate any formula entered into a cell, this can be a problem. It is best not to set the format of a cell as Text.

For an optimal Community experience, Please view on Desktop