Auto-Fill Glitch

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
 
M

Michael

Hi Toni
Highlight all the cells and then goto:
Format, Cells, Number, 2 Decimal Places
Regards
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Calculate Question / HELP! 2
Auto-fill 1
Conditional Formatting from a group 6
Auto Fill function in Excel 2007 not working properly 4
VLOOKUP and Auto Fill problesm 1
auto fill certain data from sheet1 to sheet 2 2
Filtering data 2
Auto-numbering 10

Top