Tools Options, on the Calculation tab select "Automatic".

"Jim at SDSU" wrote:

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