---
title: Removing Scientific Notion from Your Client List Report
description: "If you open a Client List Report in Excel after building the report to send to GloveBox, the policy numbers may switch to a Scientific Notation, which GloveBox can't use.\n\nFollow these steps to revert your policy numbers to the appropriate format."
---
[Skip to content](https://gbu.gloveboxapp.com/knowledge/eliminating-a-scientific-notation-policy-number#main-content)
English
Show submenu for translations
- [GloveBox Website](https://glovebox.io/)
Open main navigation
Close main navigation
- [GloveBox Website](https://glovebox.io/)
- English
Show submenu for translations
How can we help you?
- There are no suggestions because the search field is empty.
1. [GloveBox University](https://gbu.gloveboxapp.com/knowledge?hsLang=en)
2. [GloveBox and Your AMS Data](https://gbu.gloveboxapp.com/knowledge/glovebox-and-your-ams-data?hsLang=en)
3. [Additional AMS Data Resources](https://gbu.gloveboxapp.com/knowledge/glovebox-and-your-ams-data?hsLang=en#additional-ams-data-resources)
# Removing Scientific Notion from Your Client List Report
## If you open a Client List Report in Excel after building the report to send to GloveBox, the policy numbers may switch to a Scientific Notation, which GloveBox can't use. Follow these steps to revert your policy numbers to the appropriate format.
Scientific Notation will change your policy number from the standard format and update it to a decimal format. This is because the CSV file will recognize the Policy Number as a very large number, which scientific notion is intended to simplify.
However, because GloveBox wants to pull in your correct policy numbers, we want them in the standard number format.
If you find that your Policy Numbers have been converted to scientific notation within your Client List report, follow the steps below.
**Step 1: Navigate to Column F**
Within your CSV file, navigate to Column F, or whichever column hosts the policy numbers. Select the letter 'F,' which will highlight the entire column.
- With the cells highlighted, right click or control-click. A menu will generate.
- Within the menu, select 'Format Cells.'
**Step 2: Revert Formatting**
Once you select 'Format Cells,' change the format from 'General' to 'Number.'
- You should see zero decimal places once the change has been made effectively.
- After you verify the updated format, click 'OK.' Then, 'Save' the file using the floppy disk icon.
- Now, you're ready to send your report to clientlist@gloveboxapp.com.
For additional assistance, check out the video below.
- [GloveBox Quick Links (Start Here!)](https://gbu.gloveboxapp.com/knowledge/glovebox-quick-links-start-here?hsLang=en#main-content)
- [Key GloveBox Resources](https://gbu.gloveboxapp.com/knowledge/glovebox-quick-links-start-here?hsLang=en#key-glovebox-resources)
- [GloveBox Training Events](https://gbu.gloveboxapp.com/knowledge/glovebox-quick-links-start-here?hsLang=en#glovebox-training-events)
- [FAQs](https://gbu.gloveboxapp.com/knowledge/glovebox-quick-links-start-here?hsLang=en#faqs)
- [Client Onboarding Resources](https://gbu.gloveboxapp.com/knowledge/client-onboarding-resources?hsLang=en#main-content)
- [Completing Your Account Set-Up](https://gbu.gloveboxapp.com/knowledge/client-onboarding-resources?hsLang=en#completing-your-account-set-up)
- [Email Campaigns to Promote GloveBox](https://gbu.gloveboxapp.com/knowledge/client-onboarding-resources?hsLang=en#email-campaigns-to-promote-glovebox)
- [Launching and the GloveBox Rollout](https://gbu.gloveboxapp.com/knowledge/client-onboarding-resources?hsLang=en#launching-and-the-glovebox-rollout)
- [Agency Internal Process Updates](https://gbu.gloveboxapp.com/knowledge/client-onboarding-resources?hsLang=en#agency-internal-process-updates)
- [Key GloveBox Workflows](https://gbu.gloveboxapp.com/knowledge/key-glovebox-workflows?hsLang=en#main-content)
- [Managing Client Profiles and Policies](https://gbu.gloveboxapp.com/knowledge/key-glovebox-workflows?hsLang=en#managing-client-profiles-and-policies)
- [Driving Client Adoption with GloveBox](https://gbu.gloveboxapp.com/knowledge/key-glovebox-workflows?hsLang=en#driving-client-adoption-with-glovebox)
- [Resources for Agency Administrators](https://gbu.gloveboxapp.com/knowledge/key-glovebox-workflows?hsLang=en#resources-for-agency-administrators)
- [Glovebox Updates + Enhancements](https://gbu.gloveboxapp.com/knowledge/glovebox-updates-enhancements?hsLang=en#main-content)
- [Latest Release: PolicyAssist](https://gbu.gloveboxapp.com/knowledge/glovebox-updates-enhancements?hsLang=en#latest-release-policyassist)
- [Now Available: GloveBox's White Label App Offering](https://gbu.gloveboxapp.com/knowledge/glovebox-updates-enhancements?hsLang=en#now-available-gloveboxs-white-label-app-offering)
- [GloveBox and Your AMS Data](https://gbu.gloveboxapp.com/knowledge/glovebox-and-your-ams-data?hsLang=en#main-content)
- [Setting Up Your Client List By AMS](https://gbu.gloveboxapp.com/knowledge/glovebox-and-your-ams-data?hsLang=en#setting-up-your-client-list-by-ams)
- [Additional AMS Data Resources](https://gbu.gloveboxapp.com/knowledge/glovebox-and-your-ams-data?hsLang=en#additional-ams-data-resources)
- [Carrier Connections + Integrations](https://gbu.gloveboxapp.com/knowledge/carrier-connections-integrations?hsLang=en#main-content)
- [Applied EPIC SDK Data and Documents Integration](https://gbu.gloveboxapp.com/knowledge/carrier-connections-integrations?hsLang=en#applied-epic-sdk-data-and-documents-integration)
- [Book of Business Carrier Connection](https://gbu.gloveboxapp.com/knowledge/carrier-connections-integrations?hsLang=en#book-of-business-carrier-connection)
- [Policyholder Resources for ClientHub and the Mobile Apps](https://gbu.gloveboxapp.com/knowledge/policyholder-resources-for-clienthub-and-the-mobile-apps?hsLang=en)
- [Resources for GloveBox CRM Clients](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#main-content)
- [GloveBox CRM Account Setup](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#glovebox-crm-account-setup)
- [Managing Service with GloveBox CRM](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#managing-service-with-glovebox-crm)
- [Utilizing GloveBox CRM's Pipelines](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#utilizing-glovebox-crms-pipelines)
- [Building & Managing Campaigns in GloveBox CRM](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#building-managing-campaigns-in-glovebox-crm)
- [Using GloveBox CRM's Medicare App](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#using-glovebox-crms-medicare-app)
- [Integrations](https://gbu.gloveboxapp.com/knowledge/resources-for-glovebox-crm-clients?hsLang=en#integrations)
- [Agency Best Practices](https://gbu.gloveboxapp.com/knowledge/agency-best-practices?hsLang=en)
[](http://Gloveboxapp.com)
*Still need assistance?
Contact us at: [support@gloveboxapp.com](mailto:support@gloveboxapp.com)*
[mailto:support@gloveboxapp.com](mailto:support@gloveboxapp.com)
Copyright © 2025, GloveBox Inc.