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) |