enetering fed ex tracking # in cell

  • Thread starter Thread starter EXCEL
  • Start date Start date
E

EXCEL

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding recognised Zeros 5
Validation 3
Last Modified By in a cell by user 3
Making text appear in cell as written 1
VBA set thick borders around non empty cells in range 0
Displaying zeros in cells 2
How to keep 0 in front of # in excel (ex: 018787766316) 6
zero in cell is counting as one... 2

Back
Top