Either some of them are formatted as text, or you have blank cells between
the sections and need to select all the cells involved.
(It text format, reformat the cells then copy a blank cell & Edit/paste
special and include "Add" as the operation.
Bob Umlas
Excel MVP


"Elcar" wrote:

Column A sorts dates in two groups. How do I correct that? Other columns sort
fine.