How to Enter Numbers with a Fixed Number of Decimal Places or Trailing Zeros in MS Excel XP

Filed under: Excel, How To 
  1. Click the Tools menu and then select Options.
  2. Click the Edit tab.
  3. Check Fixed decimal option.
  4. Use the arrows of the Places field to enter a positive number of digits to the right of the decimal point or a negative number for digits to the left of the decimal point. Note: Data entered before selecting these options is not affected.
  5. Click the OK button.


Leave a Reply

You must be logged in to post a comment.