noob excel question

By Raz
Jul 15, 2004
  1. a quick stupid question :D

    In Excel how do I get cells to default to certain decimal places e.g. if I enter 1200 it enters 12.00, or 14300 enters 143.00. I should know this but can't do's old age you see.

    TIA :blush:

  2. Rick

    Rick TechSpot Staff Posts: 4,573   +65

    Right click on the cell and choose "Format Cells" from the menu.

    It should open up a new window with the tab called "Number" selected by default. In this tab, select "Number" and then put in "2" for decimal places.

    Click OK and now everything you put in the cell will be formatted for decimals the way you would like.

    The help section on Excel is one of its best features actually, and you can find quick solutions to a lot of questions like these as you use it by going to the help menu.
  3. Raz

    Raz TS Rookie Topic Starter Posts: 37

    thanks for the reply Rick.

    But if I enter 1942 i want it to show 19.42 rather than 1942.00? Can I get it to do that?

    Thanks again :)
  4. RealBlackStuff

    RealBlackStuff TS Rookie Posts: 6,503

    No, you will have to enter the full stop as in 19.42
    Entering 194.2 will show up as 194.20

    If you have lots of numbers to enter, press the num-lock key and use the decimal pad on the right of your keyboard.
Topic Status:
Not open for further replies.

Similar Topics

Create an account or login to comment

You need to be a member in order to leave a comment
TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...

Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.