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.