can you calculate sheet to 2 decimal places

J

JBW

My wife and I set up a fantastic invoice for her very fussy boss, all
invoicing was previously in word and completely manual.

having been shown the invoice which is displayed to 2 Decimal places he's
arguing that it's innacurate as with a calculater its $0.01 out. I have
explained to my now stressed wife that its because excel calculates to 15
places and although the shown figure is rounded up, the actual figure still
remains behind the scenes as is.

Can you get excel to calculate everything to 2 dp?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addition errors with Decimal Places 6
Decimal Places 1
Can surplus decimals be omitted when adding derived figures? 2
Calculate to the third decimal and round up or down in cell 6
Formatting and adding cells formatted to 2 decimal places 3
Decimal places in mail merge 1
Round to 2 decimal places 2
Variable Defined as Double is entered in cell with only 2 decimal places 2

Top