View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default enetering fed ex tracking # in cell

You sure the number is only 13 digits?

Excel will use15 digits then turn everything after that to 0's.

I have not heard of a 13 digit number being truncated in this manner.


Gord Dibben MS Excel MVP

On Tue, 4 Mar 2008 08:07:02 -0800, EXCEL
wrote:

Hello,
I cannot find a way to enter the 13 digit tracking # in a cell, I have tried
custom, general - it always replaces the last 6 #'s with zeros? Any advice?