Currency data type invalidates any value above 999.99

Currency data type invalidates any value above 999.99

I imported sales data from Amazon via an XLSX file. The data type in Excel was "Currency". Data prep is showing any value of $1000 or over as invalid. I tried deleting the $ and any commas, removed whitespaces and still any value above that amount comes up as invalid.

Not sure what else to do. Any ideas?


      • Sticky Posts

      • Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

        We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,

      • Zoho DataPrep is now launched!

        We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data