software

I am entering a formula to divide quot;B2quot; by 100 as b2/100. In the particular
spreadsheet the correct answer is 2.77. When I quot;Fill-gt;Downquot; The correct
formula is put into each cell e.g quot;=b3/100quot; and =b4/100quot; but the spread sheet
displaies 2.77 in each of those cells. Any ideas??

Tools gt; Options, on the Calculation tab select quot;Automaticquot;.

quot;Jim at SDSUquot; wrote:

gt; I am entering a formula to divide quot;B2quot; by 100 as b2/100. In the particular
gt; spreadsheet the correct answer is 2.77. When I quot;Fill-gt;Downquot; The correct
gt; formula is put into each cell e.g quot;=b3/100quot; and =b4/100quot; but the spread sheet
gt; displaies 2.77 in each of those cells. Any ideas??



quot;SVCquot; wrote:

gt; Tools gt; Options, on the Calculation tab select quot;Automaticquot;.
gt;
Perfect. Normally that is the default. I didn't even think about that!

THANKS!!