Jonathan
Your pictures did not come through.
Just type out some examples of your data and what it does or doesn't do.
If entering formulas, sounds like your cells have been formatted as text.
Copy an empty cell formatted as General.
Select your data and, in place, Paste Special>Add>OK>Esc
Just a guess but I'm rounding up the usual suspects.
Gord Dibben MS Excel MVP
On Tue, 11 Jul 2006 19:24:01 -0700, Jonathan
<Jonathan[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >Dear Sir,
> The autofill function of Excel seems to be damaged. The following figures
>showed what happened when I use autofill function with my PC.
>
>
>
>
> When I click the cell with the wrong result, I found that the function is
>correct but the number is wrong as following figure shows.
>
> After I double click the cell with the wrong result, I will enter the edit
>mode for the cell. I just press enter, the cell will show the right result
>then as following figure shows.
>
> This is really strange. Please help me to solve it. Contact me if necessary.
|