I have a report that is using a simple formula if the criteria is met from one table (doc name and status) then return the date. The information comes back perfectly in Crystal but when I try to export it to an excel sheet regardless of the excel version (max version is 8.0 extended) I am getting a long number for all of the fields whether there should be a date or not. I have formatted the date and still cannot come up with a solution for this problem. Please help! Terri Mimbs