On Tue, 15 Mar 2005 01:14:08 -0600, "Robbie in Houston"
wrote:

I'm trying to format a column of numbers for USPS tracking numbers.
However, no matter how many different ways I try the custom number format
option, it only picks up the first 15 digits of the 22 digit number, and the
rest display as zeros.

Excel's specifications:

Number precision: 15 digits

So any NUMBER you enter over 15 digits will only display the first 15
significant digits.

In order to enter longer strings of numeric data, you must format the cell as
TEXT.


--ron