Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Formatting Cells as Text


In Jet Essentials and versions of Jet Reports 2010 and higher, setting the Number 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.

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments