ToolsOptionsEdit.

Uncheck "Fixed Decimal Places"

Handy feature if you are an Accountant but otherwise not too handy.


Gord Dibben MS Excel MVP

On 23 Feb 2007 10:26:42 -0800, wrote:

When I enter a number in a cell, Excel somehow divides the number by
100 ie. entering 1234 gets a value of 12.34 in the cell.

What have I done wrong.

enenko