I do not want formula to round out the number how do I turn off

  • Thread starter Thread starter sandowb
  • Start date Start date
S

sandowb

How do I turn off number rounding. I have reduced the decimal place to 0.
 
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)
 
You must log in or register to reply here.

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

How do I get excel to stop rounding numbers 3
How do I round off a number to 333.00 instead of 332.84? 3
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
rounding in excel 3
ROUND 2
can you round a number then use it in another formula 4
How not to round a formula 9
add rounded numbers using the rounded value 2

Back
Top