In Excel, click on Tools | Options | Edit | check the "Fixed decimal
places" box and set the number of decimal places to 2 | OK.

Aln54 wrote:

Is there a way I can format my numbers so when I enter 12345 they will show
as 123.45 without me having to enter the decimal?