Auto-Fill Glitch

  • Thread starter Thread starter Toni
  • Start date Start date
T

Toni

I input data in 3 cells, i.e. 32.11, 32.12, 32.13; then
drag to auto-fill 100 cells. The data looks correct, but
after about 10 cells, clicking on individual cells show
data such as 32.7200000000002. Any fixes?
Using Excel 2002 (10.4524.4219) SP-2
Thanks
 
Hi Toni
Highlight all the cells and then goto:
Format, Cells, Number, 2 Decimal Places
Regards
Michael
 
Back
Top