UPS
Login SettingsProfileAccount SummaryAdministrationAddress BookMaintain Your UPS Account
Create a ShipmentView HistoryVoid ShipmentCreate a ReturnShip Using a Batch FileCreate an ImportCalculate Time and CostSchedule a CollectionUse International ToolsOpen a UPS AccountOrder SuppliesSet Preferences
Track ShipmentsLearn About Quantum ViewAdministrationQuantum View ManageAccess Flex Global ViewIntegrate Tracking APIs
Critical FreightAir FreightOcean FreightCustoms Brokerage Services
UPS Customer CentresMail Boxes Etc.
Getting StartedShippingTrackingReceiving Your ShipmentBilling and PaymentTechnology Support
Why is the account number shown as a formula in the Billing Data File?

The account number is shown as a formula because the billing data file has been imported into Microsoft® Excel under a General format instead of a Text format. When this happens fields which contain the letter E display as scientific notation. You can fix the problem by changing the file suffix from .csv to .txt and saving the new file.

Note: This problem will not occur with the Billing Analysis Tool because the tool imports alphanumeric fields as text values.

 Back to Top
View Examples

Other UPS Sites:

Copyright © 1994-2012 United Parcel Service of America, Inc. All rights reserved.