|only dates (in columns) and text (in columns)|
Are you getting this data from another application?
Make sure your DATES are really dates, often times when importing
the data, Dates do not get recognized and are treated as TEXT by Excel.
Also, in your TEXT columns make sure there are no stray unprintable
You can use the =TRIM() & =CLEAN() functions to clear them out.
Something like: =TRIM(CLEAN(A1))
Also, make sure your BLANKS are really empty, which may have
the same problem as TEXT.