On Feb 22, 8:53*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Are the product numbers actually numbers or are they text. If they are text
perhaps the number is padded at the end with blanks?
--
HTH...

Jim Thomlinson



"PatG" wrote:
I receive a monthlyspreadsheetfrom another department that I re-sort by
product numbers using a custom sort list.
Recently one of the product numbers was not being recognized so it would be
pushed to the end of the list every time. It also was not recognized when
running a macro.
I found that by "clearing" the cell and re-typing the product number fresh,
it will get picked up and appear at the correct place on the list after
sorting.
(NOT deleting, or cut/pasting or copy/pasting or paste-special value only -
none of which work)
Any idea what causes this?
Using Excel 2003- Hide quoted text -

- Show quoted text -

Maybe you can try a popular Excel file recovery tool called Advanced
Excel Repair to repair your Excel file. It is a powerful tool to
repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan