enclose your formual in a ROUND() function:

=ROUND(1-(L851/K851),1)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"kleivakat" wrote in message
...
I have a column in a spreadsheet that contains a formula:

=1-(L851/K851)

Using this formula, I calculate the percentage discount that a customer
gets
off a particular item. I formatted the column as a percentage with one
decimal. The result shows a number with one decimal that is correct.

However, when I move that into a pivot table, I get the multiple decimals
(up to 15 digits). So I can't group calculate everything that is say
47.5%
discount. I have multiple 15 digit numbers all listed separately that
would
round to 47.5%. My pivot table field is also formatted to a single digit.

So I think that maybe I need to round the results in the original data.
Which brings me to my very basic question. How do I do that? I found the
section on worksheet functions, but I don't know how to put that into each
cell with the formula.

What is my formula if I want to round this to a single decimal result?
Again, my current formula is:

=1-(L851/K851)

Thanks.

Kathy