 So you're in Excel and you want to enter a number, let's say with three significant figures, 2.00. Chances are high that Excel will do something you don't really want. So you need to tell Excel how many digits you actually wanted to show. For this you can use either these two buttons up here to increase or decrease the number of decimals. The other option is right click on a PC or a fourth click on a Mac and then you go down to Format Cells and then you can tell here how many decimal places you actually want. Here you could also change it to scientific notation if ever you wanted that. And that's how you can make Excel show the amount of secrets you actually want.