Numeric allow percent (%) and engineering notation

Version: 2019

Type: Features

Category: Data Handling

Subcategory: Workbook and Worksheet

Jira: ORG-18380

  • Type 12% will convert it into 0.12 automatically. You can disable it by system variable: @cap=0

  • Convert Percent (%) to Number when Copying or Importing ASCII or Excel Data with %

  • Type "1k" in a cell, then convert column to Numeric format will change it to 1000 automatically.