Actually one last thing...is there a way to delete the column with the =NOW() date without ruining the ages. Or maybe a way to copy that column without the formulas. I have to use a certain format to import this into another program and it has to go column 1:DOB, Column 2: Age. Do you know what i mean?
Thanks again
Will that other program import directly from Excel, or do you need to save the Excel data in a different format before you can import? I believe you need to keep all formulas in your main Excel file; otherwise, you'll have to recreate it each time you want to update it.
If you only want import the age column, you could use Copy and Paste Special | Values to paste the values, not the formulas, from the age column to a separate Excel workbook. Then, you could save that file as Text (.txt) or Comma Separated Value (.csv), or whatever works best for the import procedure.
Edit: Just for the info, I'll be away from my computer for awhile.