How do I turn off number rounding. I have reduced the decimal place to 0.
J John C Jul 15, 2008 #2 Decimal place to zero will round to the nearest whole number. What kind of number are you looking at? Go to Format--Cells--> and on the Number tab, choose General formatting. Note: It will still round to fit the width of the cell.
Decimal place to zero will round to the nearest whole number. What kind of number are you looking at? Go to Format--Cells--> and on the Number tab, choose General formatting. Note: It will still round to fit the width of the cell.
B Bob Phillips Jul 15, 2008 #3 If you have reduced the decimal places, it is not being rounded, it is just showing as rounded. The actual number has all of the decimal numbers. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
If you have reduced the decimal places, it is not being rounded, it is just showing as rounded. The actual number has all of the decimal numbers. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
