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?
Deliver unforgettable customer experiences
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
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
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.