# Range of Numeric Values that Can Be Entered or Stored in Cells

The maximum numeric value that can be entered (manually) into a cell of STATISTICA spreadsheets is: ±9.99999E+30 (i.e., ±9.99999..*1030), that is, less than the absolute value of 1E+31.

Note that this limit applies not to the maximum value that can be stored in a cell (which can be much greater, see below), but rather to the conditions that trigger the warning message when you enter data into a cell. The purpose of that warning is (a) to protect against typos when entering values in scientific notation (and when entering just a single digit by error, could potentially change a value in a reasonable range into a value of an astronomical magnitude), and (b) to discourage entering unreasonably large values (see below).

Real numbers (Double) are stored in STATISTICA in a 64-bit IEEE floating point notation with the range of ±1.79769313486231E+308  (i.e., ±1.79769313486231*10308), but this limit pertains to the maximum values that can be internally stored (and which potentially could be a result of multiplying the raw data values, e.g., squaring them) and, therefore, using extremely large data values as raw input data is not recommended. Such data should be re-scaled after importing them into STATISTICA, which normally will not involve any loss of information (i.e., precision).

You can enter data as large as 9.9999..E+30 into a cell (as mentioned above, a warning will be displayed if you attempt to enter a larger value), but cells can store much larger values - you can also import much larger values into STATISTICA or create them in STATISTICA as a result of transformations (via the spreadsheet formulas or STATISTICA Visual Basic powerful math library).