Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
I receive a monthly spreadsheet from 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
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 monthly spreadsheet from 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
You might have non-printable characters in the cell. If the cell A1 appears
as being ABCD then =LEN(A1) should say 4. If there are hidden characters in the cell, the answer will reflect them. Perhaps the other dept. entered the part number as ABCD with hidden characters and is now sending those to you. A fast way to see if there are non-printables is just to select the cell, press F2 and watch the cursor as you step across the cell with the left arrow key. There should be a visible character to the left of the cursor for each character except the first.. Tyro "PatG" wrote in message ... I receive a monthly spreadsheet from 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
That's it!! They each had a blank space after them!!
Thank you Tyro and Jim!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Corrupt Cells?
Do you really believe that the problem could be caused by a corrupt workbook?
Don't you think that Alan's suggestion is much more likely? Or is this just a not so veiled advertisement? Alan wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt data question.. | Excel Discussion (Misc queries) | |||
Corrupt .xltm | Excel Discussion (Misc queries) | |||
Corrupt screen on startup | Excel Discussion (Misc queries) | |||
The document is corrupt | Excel Discussion (Misc queries) | |||
Corrupt Spreadsheet | Excel Discussion (Misc queries) |