Why won't my newly entered data sort with old data ?

G

Guest

I have an excel spread sheet that the data in the column sorts newly entered
or changed data seperatly from old data.
 
G

Guest

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.
 
G

Guest

Sounds like a formatting problem.....one set is probably formatted as DATE
and the other set as TEXT



Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Tracking newly entered rows. 3
Insert empty columns in list w/o header 2
Pivot table not recognizing same field values 1
Sorting 6
problem with fractions to decimal 1
Hold conditional formatting when sorting filtered data 1
Why won't vlookup read newly entered data from a source file? 3

Top