How can I enter a “null value” (a value that is ignored when gridding or performing mathematical calculations) into the Surfer worksheet?
A. Surfer ignores any text strings (non-numeric values) when gridding and when performing Data | Transform in the worksheet. Any of the following can be used: “-9999”, N/A, “no data”, x99 In a text editor, program, or script, add quotes around a number to designate it as a text string. In the worksheet, insert a single quote (apostrophe) at the beginning of the number to convert it to text. Quotes around a text string with spaces insure that the entire string is read as a single item. A mix of numbers and text without spaces is read as a text string.
Related Questions
- How can I enter a "null value" (a value that is ignored when gridding or performing mathematical calculations) into the Surfer worksheet?
- What value can I use to specify a "null value" (a value that is ignored when creating the graph) into the Grapher worksheet?
- How to enter closing stock value in Balance sheet and Trading a/c ?