View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default make excel automatically add a decimal

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

On Mar 20, 5:22*pm, "Darrell Eddy" wrote:
Is there a way to make Excel automatically add a decimal two places from the
right, like you can program calculator to do?

Darrell