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?

            Zoho Marketing Automation
                    • 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 Pagesense Resources

                      Zoho SalesIQ Resources

                            Zoho TeamInbox Resources

                              Zoho DataPrep Resources

                                Zoho CRM Plus Resources

                                  Zoho Books Resources

                                    Zoho Subscriptions Resources

                                      Zoho Desk Resources

                                        Zoho Projects Resources

                                          Zoho Sprints Resources

                                            Qntrl Resources

                                              Zoho Creator Resources

                                                Zoho WorkDrive Resources

                                                    Zoho Campaigns Resources

                                                      Zoho CRM Resources

                                                            Design. Discuss. Deliver.

                                                            Create visually engaging stories with Zoho Show.

                                                            Get Started Now