H
HDM
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
When I copy Excel formulas/formulae down a column it copies the formulas into the cells but they display the result for the cell at the head of the column. That is, when I click on any cell in the column, the formula is displayed in the formula bar but the number (the result) shown in the cell is the result for the first cell in the column. How do I get them to display the actual result in each cell.
Please help.
HDM
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
When I copy Excel formulas/formulae down a column it copies the formulas into the cells but they display the result for the cell at the head of the column. That is, when I click on any cell in the column, the formula is displayed in the formula bar but the number (the result) shown in the cell is the result for the first cell in the column. How do I get them to display the actual result in each cell.
Please help.
HDM