No Dates

[Guest]

I have a form in Excel 2003 that will not show dates between 9-9-05 and
10-1-05. All it shows are #### marks. All other dates before and after those
dates enter perfectly. Everything else I enter on the form is as it is
supposed to be. Can anyone help me. ( Please do not tell me to stop using the
form until 10-1-05 )

 

[Guest]

First try to widen the column to see if the #### goes away.

If that does not work, then reformat the cell to General.

9/8/05 should display as 38603
9/9/05 should display as 38604

If you don't see these values, you have a data problem, not a formatting
problem.

Good Luck