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.
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)
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.