Liquid UI - WS Reference Library

3.2.5 Number and Case Validation


Case 4: Number or Case Validation

The fourth case is that validation will be performed according to either a numerical value only or an upper case value only. To set this case, if it not already selected, please do the following.
  1. Right-click on a cell in the row you want to validate and choose Data Validation from the context menu.

  2. The Data Validation wizard will appear as shown below.

  3. Select the Numerical value or Upper case only radiobutton, if it is not already selected as shown below and then click Next.

  4. The value entry screen will display as shown below.

  5. Select either the Numeric Only or the Upper Case Only radiobutton and click Next.
  6. The Finish window will display as shown below. Click Finish.

  7. The Numeric or Upper Case Validation case has now been set for this row.