Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you round a number then use it in another formula | Excel Discussion (Misc queries) | |||
Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
How do I round a formula generated number | Excel Worksheet Functions | |||
Need to round a formula up or down to a specific number | Excel Worksheet Functions | |||
i would like to know a formula on how to round a number to 500 | Excel Discussion (Misc queries) |