Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why won't my newly entered data sort with old data ?
I have an excel spread sheet that the data in the column sorts newly entered
or changed data seperatly from old data. |
#2
|
|||
|
|||
there is a good chance that some of the data, if numeric, either new or old,
it text even though it looks like numbers. If you do a quick sum() on some of the numbers, if it says 0 it is probably text. a helper column with =value(trim(A1)) then copy and paste special values will convert to numeric. There are other ways to convert text numbers to numeric, depending on what is really there. If it is text, there may be leading spaces. Check the trim() function. "laura" wrote: I have an excel spread sheet that the data in the column sorts newly entered or changed data seperatly from old data. |
#3
|
|||
|
|||
Sounds like a formatting problem.....one set is probably formatted as DATE
and the other set as TEXT Vaya con Dios, Chuck, CABGx3 "laura" wrote: I have an excel spread sheet that the data in the column sorts newly entered or changed data seperatly from old data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a hyperlink (entire row) to data sort alphabetically | Excel Worksheet Functions | |||
sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
How do I make a formula refer to given data even if I do a sort f. | Excel Discussion (Misc queries) | |||
sort data with the same result | Excel Worksheet Functions |