I have a spreadsheet, created in Excel. The columns are entitled Stock #, Product Title, Date, Retail Price, etc. It is several hundred rows long. I add new product information to the spreadsheet 2 times a year, by scrolling to the bottom of the list and adding new information in the first/next blank row.
The problem occurs when I attempt to sort the information. The new stock #?s do not sort in with the existing stock #?s. I enter the stock #?s normally (ex. 1234), but it will not sort in with the other stock #?s unless I add a decimal point after the digits (ex. 1234.).
The original stock #?s were entered without the decimal and the formatting was not changed in any way. What is going on?
(The information in the Title, Date, Retail Price column all sort normally, it is only the stock # column that is not sorting properly.)
