View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Problem entering amounts.

Sky wrote:
I am having a new problem entering amounts on an Excel Worksheet. Everytime
i try to enter 100 it comes out as 1 If I try to enter 20 then it comes out
as 0.2 I have format set to 2 decimal points as usual.


Click on Tools Options Edit. If Fixed Decimal Places is
check-marked, click the check-mark to remove it and turn off the option.