General discussion

Locked

Add Data to an existing Excell document.

By Software Girl ·
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.)

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Add Data to an existing Excell document.

by plg6 In reply to Add Data to an existing E ...

It sounds like Excel is seeing one part of the spreadsheet formatted one way, the new part formatted as another type. Thus, when you go to sort, it is based on the cell type, then the sortation logic within that type.

So when you enter the new data, go to the top of the sheet. Then go to the column with the stock number in it and highlight the whole column by clicking on the column ID itself. For instance, if it is in column "A" click the "A". Then, go to Format--->Cells. Set the whole column to be numeric, no decimal places (unless you need them) - then you should be able to sort based on this field correctly.

Collapse -

Add Data to an existing Excell document.

by Software Girl In reply to Add Data to an existing E ...

This was among the first things I did to attempt to solve the problem. This is a huge spreadsheet with several hundred rows. I have even tried reformatting the indivual cells. It just doesn't want to work for me. I am beginning to suspect a bug inmy Excel program.

Collapse -

Add Data to an existing Excell document.

by Peyison In reply to Add Data to an existing E ...

Above answer should work - it sounds like the new Stock # cells are formatted as Text. You can check this by right-clicking one of the cells and selecting Format Cells... If "Text" is selected, then that's the problem. Changing to a numeric format should fix it.

Good luck

Collapse -

Add Data to an existing Excell document.

by Software Girl In reply to Add Data to an existing E ...

Sorry, I tried this also.

Collapse -

Add Data to an existing Excell document.

by Peyison In reply to Add Data to an existing E ...

If you'd like to send my your workbook, I'd be happy to take a look at it.

mike@peyison.com

Collapse -

Add Data to an existing Excell document.

by Software Girl In reply to Add Data to an existing E ...

I am still considering the consequence of sending you the files to check. I have discovered a few new things to look for, (from the Tech e-mails I receive) so will go from there. If you offer still holds, I will contact you should I need additional help. Sorry it took so long for me to get back to you. Thank you for your help. RC

Collapse -

Add Data to an existing Excell document.

by Software Girl In reply to Add Data to an existing E ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Software Forums