software

We use forms where we need to enter our hours in. When someone tries to
enter in hours with a half, as in 12.50...it automatically changes to 13. is
there a way I can fix this so it doesn't happen?

With one of those cells selected, click on Format - Cells. Select the
Number tab. In the quot;Categoryquot; list, select quot;Numberquot;. Look at the small
window labeled quot;Decimal places:quot;. It probably shows quot;0quot;. Change it to quot;2quot;
and click OK. Now enter 12.50 and see what happens.
If this works for you, select all the cells into which you will be
entering such numbers and format them the same way. HTH Otto
quot;Suzettequot; gt; wrote in message
...
gt; We use forms where we need to enter our hours in. When someone tries to
gt; enter in hours with a half, as in 12.50...it automatically changes to 13.
gt; is
gt; there a way I can fix this so it doesn't happen?
Also, you may just need to widen the columns as sometimes the cells will
round up when the data doesnt fit.