when I enter 12.50 in a column, it automatically changes to 13?

S

Suzette

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?
 
O

Otto Moehrbach

With one of those cells selected, click on Format - Cells. Select the
Number tab. In the "Category" list, select "Number". Look at the small
window labeled "Decimal places:". It probably shows "0". Change it to "2"
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
 
V

Vix

Also, you may just need to widen the columns as sometimes the cells will
round up when the data doesnt fit.
 
Top