Use ROUND function with your formula =ROUND(<formula,2)

=ROUND(A1,2)

If this post helps click Yes
---------------
Jacob Skaria


"TKGerdie" wrote:

We have a spreadsheet we use for bidding our jobs. The summary page has 5
line items that pull from another spreadsheet. Each of those cells are
formatted to only show 2 decimal places. However, because one of the items
(materials) is a formula result is has 8 decimal places and then only shows
2. Our customer is confused as to why when he manually adds the figures they
do not match the total on our sheet. Is there any way to fix this?