How to fix figures in specified decimal place

[Stevekent]

How do I make my input in cell to be in 2 decimal each time I enter a figure. Say, If I enter a figure, say 3.567, I want it to show just 3.58, if I enter 5.2, it shows 5.20

 

[mikerickson]

Use the format 0.00

 

[Stevekent]

Thanks, how about if I want to have comma as well. Say 2153.255 become 2,153.26

 

[jolivanes]

As before.
Format - Cells - Number and put a checkmark at "Use 1000 separator"

 

[mfexcel]

Simply click the "," located in the Number Group on HOME Tab

Thanks, how about if I want to have comma as well. Say 2153.255 become 2,153.26

 

[Stevekent]

Thanks everyone for your helps. However, I've another problem related to this, i.e If I copy from a different worksheet which has not been formatted, say 3516.256 and paste on this formatted page, the result is back to 3156.256, can the paste result shows 3,516.27

 

[mfexcel]

You may Paste Value only
Right after the paste action, click the smart tag or press CTRL --> Value

Thanks everyone for your helps. However, I've another problem related to this, i.e If I copy from a different worksheet which has not been formatted, say 3516.256 and paste on this formatted page, the result is back to 3156.256, can the paste result shows 3,516.27