| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to stop rounding numbers
In calculating a differential for a golf handicapp index, the formula is to
calculate to the first decimal place and do not round. How do I turn off the rounding? -- Brian |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get excel to stop rounding numbers
One way:
=TRUNC(formula,1) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Brian" wrote in message ... In calculating a differential for a golf handicapp index, the formula is to calculate to the first decimal place and do not round. How do I turn off the rounding? -- Brian |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get excel to stop rounding numbers
Also your problem might be the formatting that you're looking at. Check and
make sure that you can see enough decimals. "Brian" wrote: In calculating a differential for a golf handicapp index, the formula is to calculate to the first decimal place and do not round. How do I turn off the rounding? -- Brian |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get excel to stop rounding numbers
-- Brian "Brian" wrote: In calculating a differential for a golf handicapp index, the formula is to calculate to the first decimal place and do not round. How do I turn off the rounding? -- Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
| How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
| How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
| How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Linear Mode
