Im trying to put in a formula in excel to divide two numbers... but when I get my long decimal number I want to shorten the answer

On the Home screen in your Workbook on the top in the middle there should be a Number dropdown box. Below this dropdown box there will be 4 icons. The icon on the right is to decrease the decimal. Just click on the Decrease Decimal box until you get the right number of places.

The box just to the left of the Decrease Decimal Box is the Increase Decimal Box.

Hi

You can use the ROUND function, for example.
=ROUND(A1/A2,2) which will round to 2 decimal places.

Definitely use the ROUND() function in your formula as that will create an actual decimal value that is under your control. If you use the suggestion in the first reply you'll still have long decimals hidden behind short formatting, not nearly as good.

For instance:

=A1/B1

Is better as:

=ROUND(A1/B1, 2)