G
Guest
Hi, I have workbook with a main worksheet which I filter then copy the
filtered records to another worksheet within the same workbook. Therefore
there are several worksheets within this workbook. On only one of these
worksheets my dates change to numbers. When I check the number format it
looks fine. I've deleted the worksheet and inserted a new one, but the
'corrupted' dates moves to another worksheet. I've already spent a fair
amount of time entering formulas,etc to this file and would rather not have
to re-do the entire file, any suggestions/solutions (or why this may have
happened?)
filtered records to another worksheet within the same workbook. Therefore
there are several worksheets within this workbook. On only one of these
worksheets my dates change to numbers. When I check the number format it
looks fine. I've deleted the worksheet and inserted a new one, but the
'corrupted' dates moves to another worksheet. I've already spent a fair
amount of time entering formulas,etc to this file and would rather not have
to re-do the entire file, any suggestions/solutions (or why this may have
happened?)