Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble in Dragging the cell
When I tried to drag the formula of the cell to another cell, the amount
supposed to be calculated on another celll did not worked. The Original amount from the original cell appears on another cell. Also, when I tried to do the formula by myself insteading of dragging, the cell shows "0". I have checked the cell and the format is number. Unfortunately, it still shows "0". Appreciate any help. -- Tim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble in Dragging the cell
On Sep 1, 3:07*pm, Tim Leung
wrote: When I tried to drag the formula of the cell to another cell, the amount supposed to be calculated on another celll did not worked. *The Original amount from the original cell appears on another cell. Also, when I tried to do the formula by myself insteading of dragging, the cell shows "0". *I have checked the cell and the format is number. * Unfortunately, it still shows "0". Appreciate any help. -- Tim Drag and then press ctrl+F9 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble in Dragging the cell
Tools Options Calculation Automatic
-- Gary''s Student - gsnu200802 "Tim Leung" wrote: When I tried to drag the formula of the cell to another cell, the amount supposed to be calculated on another celll did not worked. The Original amount from the original cell appears on another cell. Also, when I tried to do the formula by myself insteading of dragging, the cell shows "0". I have checked the cell and the format is number. Unfortunately, it still shows "0". Appreciate any help. -- Tim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble in Dragging the cell
One more thing aside from auto-calc...........
You say your numbers are formatted as a Number. It may still be text..........changing formatting does not correct this. Format all to General. Copy an empty cell. Select the range of "numbers" and paste specialaddokesc. Gord Dibben MS Excel MVP On Mon, 1 Sep 2008 03:07:01 -0700, Tim Leung wrote: When I tried to drag the formula of the cell to another cell, the amount supposed to be calculated on another celll did not worked. The Original amount from the original cell appears on another cell. Also, when I tried to do the formula by myself insteading of dragging, the cell shows "0". I have checked the cell and the format is number. Unfortunately, it still shows "0". Appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging a cell | Excel Discussion (Misc queries) | |||
Dragging & incrementing cell values | Excel Worksheet Functions | |||
number cell increment +1 when dragging down box | Excel Worksheet Functions | |||
copy one to cell to another by clicking and dragging | Excel Worksheet Functions | |||
Dragging cell data | Excel Discussion (Misc queries) |