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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spread sheet that the data in the column sorts newly entered
or changed data seperatly from old data.
 
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.
 
Sounds like a formatting problem.....one set is probably formatted as DATE
and the other set as TEXT



Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Sorting 6
Hold conditional formatting when sorting filtered data 1
Excel Data Sorting 3
Pivot Table Refresh not working properly 1
Copy data from unlocked cells 3
copy rows from one Data sheet to another sheet based on cell conte 2
Excel 2003 - Importing External Data - formatting problem? 2
Autosort in Excel 2

Back
Top