Today I found out there is a way to have Excel automatically include these zeros. You can do this by creating a custom number format. Here's how to do so.
1). Right click on the cell you want to format and choose Format Cells...
2). Click the Number tab and select Custom in the Category: list.
3). Put in your desired formatting. You can do this by building off other format types. In my case, I wanted to have a format so that the numbers 3.5562 and 55 appeared as (03.6) and (55.0), respectively. To do this the Type: box needed to have the format (00.0). This will zero fill both before and after the decimal point as well as round all numbers by one decimal place.
As you can imagine, you can customize this to zero fill based on your particular needs or desired format type. Below is an example Table 1 excerpt to show how the formatting looks.