How can I set Excel to work in 2 decimals only, not use the hidde.

[Guest]

I use Excel to calculate and pay staff wages. I set it to currencies and
use 2 decimals for cents (rounded up or down). When calculating overtime it
often introduces errors of 1 cent because it works into the hidden third and
fourth decimals. How can I limit all calculations to 2 decimals only ie
cents. I will be happy if it rounds up every time.

 

[Dave Peterson]

There's an option under:
tools|options|calculation tab
Precision as displayed

But if your cell contained 12.3273252 and you had the cell formatted as two
decimals, that value will be truncated (never to return!). You may want to save
a copy of your workbook--just in case you don't want it this, er, drastic.

I like to just modify my formulas that are important:

=roundup(a1,2)
=rounddown(a1,2)
or
=roundup(existingformula,2)

 

[Guest]

Dave,

Does setting this option on my machine on a certain worksheet transfer with
that worksheet to someone else's screen when they open it?

Allison

 

[Gord Dibben]

Allison

This is a workbook setting so affects all worksheets in the workbook and will
travel with the workbook.

Gord Dibben Excel MVP

 

[Guest]

Thanks Gord, this is fabulous news for me. What a timesaver.

Allison