Office '07

If I enter 1 or 50 I want the result to be 1 or 50 not .01 or .05.

It seems that regardless of what kind of number formatting I choose, I still have to manually enter 1.00 or 50.00 to end up with 1 or 50 in the cell?

Mark