Tools/Options/Edit uncheck the Fixed Decimal Places checkbox...

In article ,
pm hudson wrote:

For example....when I key 109 into a cell, it returns 0.00109. All numbers
are converted in this way. It adds 0.00 to each number entered. Even when
changing the formatting, it still returns the same number.