Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dates change to numbers
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?) |
#2
|
|||
|
|||
Maybe that sheet is set to display formulas:
Select the problem sheet Choose ToolsOptions On the View tab, remove the check mark from 'Formulas' Click OK Debbie wrote: 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?) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Why does Excel Copy and Paste change dates from the original when. | Excel Discussion (Misc queries) | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |