Format a worksheet to carry out all calculations to 2 decimal plac
 

Hi,

Is it possible to format am excel worksheet or whole workbook to carrry out
all calculations to 2 decimal places (ie. rounding up and down)? The problem
I have is that I use Excel to track expenses tha are also enetered in an
accounting package and get rounding errors as excel doesn't round calulations
up or down while the acounts package does.

I can get excel to display to two decima places and round an individual
value to 2 places, but don't know how to get teh whole worksheet to calculate
to 2 decimal places.

Thanks,

Phill.

yes it is possible.
select the whole sheet by clicking the small square in the
upper left corner of the sheet(above the 1 and beside the
A) then format to 2 descimals.


-----Original Message-----
Hi,

Is it possible to format am excel worksheet or whole
workbook to carrry out
all calculations to 2 decimal places (ie. rounding up and
down)? The problem
I have is that I use Excel to track expenses tha are also
enetered in an
accounting package and get rounding errors as excel
doesn't round calulations
up or down while the acounts package does.

I can get excel to display to two decima places and round
an individual
value to 2 places, but don't know how to get teh whole
worksheet to calculate
to 2 decimal places.

Thanks,

Phill.
.

See one answer at your other post.

In article ,
"Phill Barrett" wrote:

Hi,

Is it possible to format am excel worksheet or whole workbook to carrry out
all calculations to 2 decimal places (ie. rounding up and down)? The problem
I have is that I use Excel to track expenses tha are also enetered in an
accounting package and get rounding errors as excel doesn't round calulations
up or down while the acounts package does.

I can get excel to display to two decima places and round an individual
value to 2 places, but don't know how to get teh whole worksheet to calculate
to 2 decimal places.

Thanks,

Phill.

This won't affect calculations unless you have the Precision as
displayed checkbox in Tools/Options/Calculation checked.

Note that it still won't prevent all rounding errors.


In article ,
wrote:

yes it is possible.
select the whole sheet by clicking the small square in the
upper left corner of the sheet(above the 1 and beside the
A) then format to 2 descimals.

Thanks, please see other post as this seems to have got posted three times!

"JE McGimpsey" wrote:

See one answer at your other post.

In article ,
"Phill Barrett" wrote:

Hi,

Is it possible to format am excel worksheet or whole workbook to carrry out
all calculations to 2 decimal places (ie. rounding up and down)? The problem
I have is that I use Excel to track expenses tha are also enetered in an
accounting package and get rounding errors as excel doesn't round calulations
up or down while the acounts package does.

I can get excel to display to two decima places and round an individual
value to 2 places, but don't know how to get teh whole worksheet to calculate
to 2 decimal places.

Thanks,

Phill.