make excel automatically add a decimal

[Darrell Eddy]

Is there a way to make Excel automatically add a decimal two places from the
right, like you can program calculator to do?

Darrell

 

[Pete_UK]

Click on Tools | Options | Edit tab, then check Fixed Decimal.

You might like to change it back when you are done.

Hope this helps.

Pete