The autofill function of Excel seems to be damaged.

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.

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@discussions.microsoft.com> wrote:

>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.