Setting Up Cell Editor

Question

How to enable entering only numeric values in the regular report cells?

Application Area

Data format can be set up to restrict values entered into cells of regular report sheet. For example, the user can set up entering only numeric or logical values.

Source Data

Regular report sheet:

Only numeric values (integer or real) must be entered to the B0 cell.

Solution

Set up value format in the B0 cell. To do this:

Select the B0 cell.
Execute one of the following operations:

Select the Format > Cell Format item in the Cells group of the Home ribbon tab.
Select the Cell Format context menu item.
Press CTRL + 1.

After executing the operation the Cell Format dialog box opens.

Go to the Number Format tab:

Click the Set Up button. The Value Editor Parameters dialog box opens.
Select the Float Editor value in the Type drop-down list:

Select the Default Value and the Tolerance checkboxes.
To save settings, click the OK button in the Value Editor Parameters dialog box and then click the OK button in the Cell Format dialog box.

After the B0 cell is set up, when selected, (by double-clicking on the cell) it looks as follows:

Thus, the B0 cell attributes are set up so that only numeric values can be entered into this cell.