Login SettingsProfileAccount SummaryBillingAdministrationAddress BookMaintain Your UPS Account
Create a ShipmentView HistoryVoid ShipmentCreate a ReturnShip Using a Batch FileCreate an ImportCalculate Time and CostSchedule a PickupUse International ToolsOrder SuppliesOpen a UPS AccountSet PreferencesService Guide
Track ShipmentsAccess UPS My ChoiceLearn About Quantum ViewAdministrationQuantum View ManageAccess Flex Global ViewVoid a Shipment
Critical FreightAir FreightOcean FreightCustoms Brokerage Services
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 that 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-2014 United Parcel Service of America, Inc. All rights reserved.