I'm building a list showing employees, hire date, length of employment, and
wage. The list is alphabetized by last name. Format for Today's Date and Hire
Date was selected as m/d/yr. In the length column, I subtracted hire date
from today's date (=A1-A2) and and formatted the cells to show as a number. I
haven't calculated any of the Length numbers manually but comparing the
numbers to seniority they appear to be correct. Now I want to sort the list
by the numbers in the length column. When I follow the instructions in Help
for sort 0-9 or 9-0 by clicking a cell in the column and selecting AZ or ZA,
most of my data in the Length column changes to #REF and one changes to
#####. The order of my list is changing but the order of the new order isn't
clear to me. Some of my Length cells are blank for now because I won't have
access to that info til tomorrow. The blank cells are staying blank and are
at the end of both sort lists. Sure would enjoy any guesses for what I am
doing wrong. Thanks, K.