numbers in excel it automatically adds two decimal points in the .

G

Guest

If I'm typing a number in Excel 2003 and it doens't contain any decimal
points, Excel automatilly adds one or two for me. The example I indicated
above refers to me entering "8" (for the number of hours worked in a day) and
after typing it, it appears as "0" in the cell and ".08" in the total column.
I've tried Format > Numbers > Text and this works, but I have to do it on an
individual basis. I'd like to turn this off completely.
 

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

Excel 2007 adding a column of negative and positive number 2
Decimal points data not displaying as expected 2
Formula to identify decimal versus whole numbers 12
Numbers changing between sheets 13
Decimal 1
Fixed Decimals in Excel 2007 4
Sum of numbers with only two decimal places wrong 2
Excel adds phantom decimal places: why? 1

Top