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

J

John C

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

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.

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
rounding in excel 3
Round formula 1
What do these numbers mean in the rounding formula? 2
Rounding Up 3
Is there a function to round down in Excel? 5
Number Field Automatically Rounding Decimals 3

Top