A colleague of mine mentioned that when entering data with the number
pad as opposed to the row of numbers at the top of the keyboard the
format of the cells is changed to text. The problem I am having is
that our Chip # column (each tagged animal has a unique chip # for
Identification purposes) may consist of numbers alone of numbers and
letters. When I make a pivot table it does not class the number
6443322 with all the 6443322's if one is formatted in text and one a
number. I get the error green corner of the cell saying number
formatted as text and if I change it it still will not work. Does
anyone have experience with this that I can solce my problem?
Thank you for your help!
K


--
raindancer
------------------------------------------------------------------------
raindancer's Profile: http://www.excelforum.com/member.php...o&userid=31289
View this thread: http://www.excelforum.com/showthread...hreadid=509583