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.
Hit <enter too soon.
In order to enter the longer numbers, you must pre-format the cells as text or
precede the entry with an apostrophe ('). The latter tells Excel to treat the
string as TEXT, but will not display in the cell.
--ron
|