If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
The autofill function of Excel seems to be damaged.
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 SpecialAddOKEsc 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 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting Getpivotdata function in Excel '03 to Excel '00?? | MK | Worksheet Functions | 4 | July 19th, 2006 04:21 AM |
Excel option to store trendline's coefficients in cells for use | Miguel Saldana | Charts and Charting | 9 | June 20th, 2005 08:45 PM |
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Alain79 | General Discussion | 4 | June 14th, 2005 07:34 AM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
RANDBETWEEN function to work in Excel? | M. Cade Smith | Worksheet Functions | 7 | October 4th, 2004 06:26 PM |