I do not want formula to round out the number how do I turn off
How do I turn off number rounding. I have reduced the decimal place to 0.
|
I do not want formula to round out the number how do I turn off
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. -- John C "sandowb" wrote: How do I turn off number rounding. I have reduced the decimal place to 0. |
I do not want formula to round out the number how do I turn off
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) "sandowb" wrote in message ... How do I turn off number rounding. I have reduced the decimal place to 0. |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com