Numeric allow percent (%) and engineering notation
Category: Data Handling
Subcategory: Workbook and Worksheet
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.