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

August 21, 2007 by
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.

Comments

Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.