Help Center

Export: Excel Does Not Detect Numbers

Last Updated: Feb 01, 2016 03:17AM EST
It is a known issue that Excel sometimes only detects some fields as numbers. Read more at http://support.microsoft.com/kb/181298.
 
There are multiple ways to solve this:
 
  • Solution 1
    • Use the CSV export instead, and during import you can map the columns to the correct type (if not detected automatically).
  • Solution 2
    • Select all the data (CTRL-A)
    • In the top-left corner you will now see the exclamation mark symbol.
    • Clicking the symbol will give you the option, "Convert to Number".

That should do the trick!

Contact Us

support@engagor.com
http://assets0.desk.com/
false
engagor
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete