sort in excel 2003

i am having 3 columns
Column A Column B Columm C
Formula Name of Person Date

Formula in Column A (=A1+1)

WHEN I SORT the column A gives me Value instead of Number that is there.

any help is highly appreciated.

Thanks